Star Trek: 25th Anniversary is the best of the bunch if you like the original series or at least don't mind point and click, it does an excellent job of being a game set over a series of Star Trek episodes with all the crew chemistry at work. It's sequel Judgement Rights is equally good if not better. I'm not sure if it's worth buying a legitimate copy but remember to have the manual as it's unique DRM involves star charts.

Armada I and II are good if you like RTS and would prefer a combat game. There's still an active modding community using total conversion mods (Fleet Operations if you like being curbed stomped) - Star Trek Armada III which is a total conversion of Sins of a Solar Empire is also well worth playing.

Elite Force I and II are okay if you want a FPS but pew-pew isn't really Trek.

To be honest only 25th Anniversary is worth classifying as a good Star Trek game. I'm not sure if there's anything that really captures the comfort of being a crewman on the Enterprise D.

I had a lot of fun playing Bridge Commander back in the day, but then again, I was eleven, so I don't know how well it actually played, if you could even run it today.

As already said, the Armadas are actually really nice RTS games.

I think the giant long list of Trek games says all it needs to say though - just a load of shite pumped out to make money.

My dream game is basically being a Federation captain and helping people around the galaxy, managing my crew. Mass Effect but everything's a bit nicer, basically.

>>25422
>I'm not sure if there's anything that really captures the comfort of being a crewman on the Enterprise D.

What a missed trick. I think this is the core appeal of the show, at least of TNG and onward. As >>25426 says, Mass Effect came somewhat close to capturing a nice crew dynamic and a bit of adventure/exploration, but was far from utopian and enlightened. I sure as fuck wouldn't want to live in the Mass Effect universe.