StarTrek Bridge Commander
On one hand its an 8 year old game with graphics and mechanics very much of there time. Its buggy, its unable to run at my monitors default resolution and modding it frequently makes it throw its toys out of the pram and refuse to give you anything but a black screen and a combadge.
On the other hand, with mods, its still able to pull off some rather good graphics and has enough gameplay mechanics to challenge players even now. From a damage system that manages to offer both precision attacks on specific systems though to simple "Shoot'em up" depending on your style of play and the ship your flying. You can command the ship directly with manual controls, managing all the ships systems alone. Or you can switch to bridge view and take on the role of captain, giving orders to your crew - crew who have AI that generally speaking reacts well to the situations they face. And both systems work, your not hamstrung regardless of which method you use.
Its one of the few truly good StarTrek games, despite coming out of Activision, and I can't think of another game that has come close to its unique gameplay style and balance.
I just wish the blasted thing wasn't so god damned buggy!