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.