So this is just to get an idea of what experiences people have had, but what games have others played with strategy games set in space?
Tons. MOO 1/2/3, SOTS 1/2, Distant Worlds, Stardrive 1/2, GalCiv 2/3, and Endless Space jump to my mind immediately. Sins of a Solar Empire is more of an RTS, but I've played plenty of that too. Never got around to Aurora or the Space Empire games though.
All of them including Aurora and Space Empire 3/4/5. Plus many many more, even played stars many moons ago. A few gems floating around with too many bad ones in recent years. Armada 2526 and Lost Empire were pretty solid also. Although things like Legends of Pegasus had some great features and innovative ideas, the devs unfortunately were unable to deliver.