Don't go into ST games. They're no good IMO.
In all other cases I would agree 100% with this, but Starfleet Command 2 & 3 (Yeah, Starfleet Command, not Fleet Command as I posted earlier... I remembered wrong) are actually not bad at all. Main reason is that they're not games made at a whim to capitalize on a license. They are games made based on a system developed for a space-warfare board game, and since that board game also includes ST vessels, that was a good choice to get the computer game some attention. It would work regardless of what the ships used were called or looked like.
I do prefer 2 over 3 though, as that has a lot more complexity and choice as far as ship classes go, while 3 was somewhat simplified and mostly includes just ships seen on-screen at some point. Can't argue with the price on ST:FC3 though, just check HOTU, so it's worth a look because it's free if nothing else.