Growing up there weren’t a lot of Star Trek games. The closest thing I had was Trek on my IMSAI 8080 in the 70s as well as the Star Trek pinball game and then the Star Trek Arcade game in the early 80s.
In the mid 80s I tried Kobayashi Alternative which was a buggy mess that crashed perpetually, but did enjoy The Promethean Prophecy,
However the games after that overall just were pretty bad until Starfleet Command, in which I always enjoyed that series with III getting more hours than the rest. Elite Force series had some good (and bad) ones in it as well but nothing the RTS features of Starfleet Command always got me.
Gotta give some sports game love too.
NFL 2K, enjoyed playing it with friends a lot more than madden at the time.
Fire Pro Wrestling D - absolutely one of the greatest wrestling games of that generation IMHO. I remember my friends and I trying to figure out WTH we were doing for awhile before getting the hang of it.