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's plenty of indie space sims coming through the pipe. Space Engineers, Kerbal Space Program, Planetary Annihilation, Kinetic Void, Strike Suit Zero, just to name a few.
I would would recommend X3: Terrain Conflict. There's much more to it than Tie Fighter or X-Wing though (but can arrange massive battles like either one). I loved the LucasArts Space sims, but X3 has been as good of substitute as I have been able to find. You not only get to fly fighter craft, but also command capital ships as well as buy/sell upgrades. It's sort of a Sandbox RPG space sim that also has a storyline if you want to follow that.
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.
EVE Online's fighting seems incredibly boring and static, the antithesis of TIE fighter's dogfighting gameplay. Great to read about the shenanigans though.