My favorite overall is probably Bridge Crew, because there’s nothing better than cruising around in the OG NCC-1701 Enterprise with your pals.
I also liked Elite Force when it came out, because it was crazy to see the 3D Trek environments even though they’re unimpressive by today’s standards. It even got me to watch Voyager.
Yeah, the 25th anniversary TOS point & click game was another pick of mine. It’s the only Trek adventure game I’ve played though, maybe I should check out some of the others.