I remember Distant worlds: universe scratching that itch for me a while ago. I know there is a distant worlds 2 but it might be a bit before it reaches the same scale. Nothing quite like a game so immense that by default it does most of it for you and just asks you to sign off on things (that option can be changed ofc).

Unsure how it runs these days, it looks like steam reviews are having some issues running it but i used to play it on windows 10 just fine. Hefty sale too on steam