Adventure game fans still have lots of options these days; I feel like space sim fans on the other hand, have been largely neglected since the days of TIE Fighter.
There are a few space MMOs in the pipeline too. We're probably past the dark ages now.
X series games also have tons of mods out for them. I know there was at least a major Battlestar Galactica one that was well done and would have to double check, but there could be a Star Wars Universe one as well.