I think what's being sadly, unfortunately forgotten here is the ACE series of Star Trek PC games, including Bridge Commander, Elite Force and Legacy. Of course, they're not all perfect, but one certainly stands out from all the rest:
Star Trek: Bridge Commander is the best game ever, and you...