I know this is kind of a dead thread at this point but seeing those games really took me back.
I played Star Trek games since “Star Trek: The 25th Anniversary” - I also remember “Judgement Rites” which was a sort of sequel to 25th.
I never played the “Generations” game. Wasn’t conscious of it at all. Starfleet academy was hokey - but great fun. Back when they were putting “cut scenes” of real actors in games.
Later on I played all the others and remember spending a great deal of time in “Bridge Commander” - There were a lot of “mods” available making the ships, environments, and special effects far greater than those that came with the game. Some people really had a lot of CGI talent and made some impressive stuff.