Most of the Trek games are quite good, even great. The run Activision head with them is really damn impressive for a license like that. All the games run perfectly fine for me, except for Armada 1 which required some simple tweaking, but that was an old disc copy and not a GOG one.
A quick breakdown about the games themselves, if anyone is interested:
Hidden Evil - probably the weakest one. I still somewhat enjoy it, but it was never great and it aged a lot. The controls are something of a nightmare. If you're a big Trek fan you'll still get a nice adventure out of it, but if there's any one to skip, it's this one.
Elite Force 1 & 2 - outright fantastic games. The first game has a more interesting premise and setting, great fan service, the entire cast of the show. The second game isn't quite as immersively an episode of the show, but the gameplay is even better, and it visually holds up very well.
Away Team - my favorite of all them by a mile. Great Commandos-like tactical gameplay, a whole cast of new characters and a new ship that make it feel almost like a new show in the franchise, very good story, a graphics style that's kind of age-resistant, varied missions... it's an absolute gem.
Armada 1 & 2 - also very good, especially the first one. It has a story that feels almost like a movie bringing together elements and characters from all the TNG era shows, and while the gameplay is very familiar it doesn't feel like just a re-skin of any other game. There's lots of fun elements, like boarding and taking over enemy ships (or assmilating them as Borg), travelling through wormholes, hiding in nebulas. I haven't played the second game in a long while, but I remember it as more polished graphics with a far less interesting story.
Bridge Commander - I loved it to death years ago when I played it first. Trying to replay it last year I oddly bounced off of it. To be honest I couldn't even win any battle playing in the intended "captain mode" giving orders to the crew. I could if I just played it like a flight sim, controlling the ship on my own, but that makes for a very boring game for me. I'm not sure what I was doing wrong...
Starfleet Command 3 - the only Activision Trek game I never liked. But then I never liked the SC series before either. Maybe I'm just too dumb for it, but I found it too involved, too slow, too much to keep track of and not much fun.
Others:
25th Anniversary is a great adventure game, and it's fantastic to have the cast back. It's a demanding game though, and can easily screw you over, you can head down some pretty bad scenarios if you mess up, which is quite easy to do. Probably why I never got through the sequel.
I never played Starfleet Academy (flight sims are not my thing) and already talked about Starfleet Command.
Oh, and as a bonus, you can play the FMV games Star Trek: Borg here:
https://borgremastered.com/
