While I love Sins of a Solar Empire, I find it a bit more on the RTS side. It is quite deep for an RTS, but it has limited empire building components, so while you CAN play epic sized, epic length maps, I find it repetive because you run out of technology options and planetary development options rather quickly.
Here are my recommendations for very deep space strategy take over the galaxy games:
Galactic Civilzations 2 with all the expansions is probably your best choice.
very deep traditional turn based game with strong empire building components -- also good for artistically designing ships
Space Empires IV if you don't care about graphics
Lots of detail, ship design, empire building, technologies, etc.
I can't speak for Space Empires V, it was full of bugs, but they might all be fixed now)
Sword of the Stars with expansions
very good if you like rich ship design and the tactical RTS ship battles embedded in a turn based strategy game (kinda like Total War series has RTS battles inside of turn based)
not as good if you like sim empire building, but you can have satisfying epic length games where you are continuing to develop your technology and strategies -- it isn't the same fight over and over because there are hundreds of ways to design your ships.
Master of Orion 2 and look for the unoffical 1.40 patch
classic awesome game that holds its own today, but graphics are dated and you might not be able to get it to run on your computer. Assuming you can find a copy of it. Avoid MOO3
If you have Civ IV with Expansions, you could try the Final Frontier mod which comes with Beyond the Sword, which isn't too bad. There is also a user generated conversion mod based on the Star Trek Universe which I hear is impressive, but I haven't tried it yet. Look for this stuff at civfanatics.com.
If you are a Star Trek enthusiast, you could try and find a copy of Birth of the Federation and some of the user rebalancing mods for it. Not as old as MOO2, but old enough to be hard to find, hard to run, and it is also buggy, so you probably want to just forget that I mentioned it.