Another old set with some great ideas is Loose Files and the American Scramble, for the American Revolution. Originally a magazine article (from the 80s I think?), you can find the pdf floating around online. Three pages of rules, and super tightly focused on what makes the AWI unique. 100% worth a look if you have any interest in the period.
I think you’re right about computer games when it comes to hardcore number-crunching simulation. Computers being better able to portray fog of war is also a huge advantage. But I think tabletop games can do certain things better, especially when it comes to things like command friction. On the tabletop, when an order fails to go through or an unlucky break sees your units dissolve in a rout, you can easily understand what happened and it just becomes part of the story of the game. But in a computer game not having precise control can be very frustrating, like you’re at the mercy of opaque mechanics and the RNG.
I feel you! There's a niche of complex boardgames where they try to "simulate" things, like a colony or a submarine or a spaceship or a party of RPG characters, and I think... this is what computers are good for. This is a videogame. Boardgames ought to have a different design space. If there are lots of things to keep track of, that's a bad sign for a boardgame. Some even try to have a computer do the bookkeeping, which in my opinion is just a band-aid over inadequate design.
All in my opinion, of course. And I do love "lite" dungeon romps and "lite" RPG-like boardgames. But adding complexity I think is both a temptation and a mistake.