skeletonbow: What's strange is that despite being a Star Trek fan, I was never even aware that there were any Star Trek games on PC until GOG got some of them and I now own 4 of them here. Haven't played any of them yet, but look forward to it in the future as well as GOG getting more of them. As with Star Wars and certain other franchises, Star Trek falls into that "OH!!! Must have because it has $franchise in the name of it!" category for me - of which I'm not normally guilty of overall, but certain things like Star Wars and Star Trek bypass any form of logical reasoning that might be present and go right to the emotional instamusthave center of the brain. :)
Some Star Trek games actually are quite good; 25th anniversary and Judgment rites are fun adventure games even if one isn't that much of a Star Trek fan. If one likes the original show even a little bit, they're really great because they capture the general atmosphere of that show perfectly.
Starfleet academy is more of a mixed bag imo; I really liked it back in the late 1990s, but having replayed it about two years ago, I have to say it's pretty bad when compared to something like the Freespace games. It does have some obvious merits for Star Trek fans though (e.g. the video scenes with Kirk, Sulu and Chekhov).