[VoltairePunk]

Try Aurora 4x http://aurora2.pentarch.org/index.php . It's probably the closest to "real" and "fun" as you can get. Not that detailed as you speak, but as already mentioned by others - in reality, space is really really big and really really boring.

[muzani]

I strongly second Aurora. This is about as close as it gets to a good fun simulation.