Bridge commander with mods.
Get star trek bridge commander and download nanoFX 2.0 beta.
Even without new textures, ships etcetc, it loosk quite okay.
If you want more just get on
www.bcfiles.com and download 10+ k poly ships with several 2024x2024 texture maps.
Doesn't look that bad for such an ages old game doesn't it :
http://screenshots.filesnetwork.com/8/potd/1208694028_65.jpg
BOTF is still a favourite shame it's unstable.
Google botf armadafleetcommand and you'll find a good fansite for it.
The newest one (legacy) aint really one of my favourites, although it has nice mods and gfx the gameplay is poor compared to BC imo.
Armada 2 is an RTS I quite like but i never played armada 1 and some ppl swear armada 1 is better.
Then theres those FPS wich run on the quake 3 engine, played em but were poorer games than the avg shooter.
iirc Start trek ds9 ( game) was poor.