Stellaris, lets you put colonies on autopilot. It's ripe with other problems, but handling late game scale isn't an issue unless you like to hyper optimize.
The PC version is the best, but there are Console Versions (even Switch), and IOS versions that have about 80% of the game.
I admit my thinking might be effected by quarantine but Prison Architect scratched my strategy simulator itch in a way CIV used to and hasn't for the last couple years.
It's way more contained, and more supportive of fun play sessions that are sub 30 minutes which is all I can squeeze in now.
And this game is on sale on steam very often. It was free last week though.
The most recent update to Stellaris (with admin offices) makes going wide the strongest strategy to do this by far. Still fun though.
That said, if you're going for cultural or science victories, tall is still the way to go.
try Settlers, maybe Age of Wonders? though both are fairly different from Civ and Total War