I played the original Star Trek Armada at uni in the early 00s, excellent game although for the sake of balance some artistic license with ship designs was made!
I also played Legacy and Star trek online.
My favourite though is Bridge Crew which was a great escape in the pandemic and has such huge potential when combined with a scenario editor, crew of actors and clever script