IronArcturus: Remember
Bridge Commander? Now that was a great Star Trek game!
It was a lot of fun. However I didn't like how the player ended up being sort of a faceless, voiceless captain. I get it that they were trying to get the "YOU are the captain" thing across, without giving you just some player character, but the result was kind of wonky. Of course imagination took care of that, but I always hoped for a sequel that would be even better and let you create your own avatar and have actual dialogue.
My favourite was by far the Away Team. Essentially a Commandos clone, but It had the best gameplay and story of all the ST games I've played. The Borg levels were awesome, and the whole thing felt like it could be a movie. Rather dark though, much more DS9 than TNG.
The first Elite Force was good too, despite being a straight up shooter it felt like it could well be an actuall Voyager episode.