One of the best (if not THE best) Star Trek games of ALL TIME! PS> choose to be the Borg, its da' bomb.
This is the exeption.
I love this game.
Its a little old, and the graphics arent THE BEST, but there still pretty darn good. And besides that, the game play is pretty decent to boot.
You can choose any race (expet Ferangi), and have a blast commanding a fleet of star ships!
You can even be the BORG (me reccomendation), as you can easily begin to assimilate other ships (even the very expensive ships that the AI sends at you) and add them to your arsenal, even early in the game this is quite simple.
All in all , HOURS of joy can be had with this little jewl.
BUT BEWARE: YOU HAVE TO DOWNLOAD THE PATCH, its not worth playing without. It hangs, it shuts down, you cant save skirmish games... Dont even bother. You can get the patch (V 1.2) here on this site. So dont even play once without it. Besides that, the patch is free and FAST (over broadband it takes seconds).
ENJOY!