Star Trek Excalibur
I don't know if anyone else has heard of it, but a few years ago there was a little known Star Trek game called Star Trek: Bridge Commander. It is to this day arguably the closest (and best) representation of Starship Combat in a video game. It's been modded heavily, allowing you to do things like travel to different star systems (even to go to deep space nine and travel through the wormhole and face off against the dominion).
Anyway: The very talented modders a couple of years back realised that they had reached the limitations of the Bridge Commander engine and decided to make their own, free star trek game that will merge both ship combat AND FPS sections. If their mods are anything to go by, i have to say i'm optimistic.
Site:
http://stexcalibur.com/index.html
Q & A:
Video Channel: