I played a lot of both Stars! and VGA Planets back in the day. As a kid back in the AOL era I was even big into Stars! multiplayer.
To toss my own suggestion in, fans of Aurora might take a look at Shadow Empire. It's sort of a cross between a Civilization style 4x game and a hex based wargame, and the combination worked a lot better than I expected - you do things like manage your economy by building mines, factories, various kinds of power plants, etc over your territory, but also have a large number of unit counters you spread around your land to try to manage things like defense in depth and protecting your supply lines (which are modeled and critically important, unlike most Civ style games).
The theme of the game is that you're playing a band of survivors on a colony world after the big star empire collapses. A major feature is the random planet generation, so sometimes you get basically an airless moon and sometimes it's a jungle world full of hostile alien monstrosities.
It's very detail heavy, leaning more towards complex wargame sims than a lighter game like Civ, which is why I suggest it as a similar game to Aurora (sadly it doesn't feature expansion into Space, and is purely planet based).