Are there any games like Civilization and Master of Orion where the number of units and choices in the later game don't get so overwhelming? I usually lose interest at this point but enjoy the early game. It's not the same kind of game or as grand in scale, but I really enjoyed Into the Breach because each turn you only have a limited number of choices and units each turn, and each choice feels important.
However, it achieves this by eliminating the combat, the opponent AI, and ways to revise your decision-making, instead making it more of an economic logistics puzzle with immense numbers of dependencies to consider on every turn, which makes some players used to having a build strategy to exploit and an enemy to beat up accuse it of being "not a game", always a good sign that you're on to something new and different.
It's originally a PICO-8 game, which gives some idea of how compact it is. You can still play that version right now: https://www.lexaloffle.com/bbs/?tid=30978