The smaller factions still lack a story line and diverse ship models but other than that New Horizons is the best Star Trek game I've ever played.

If only there was a way to merge the 2 games, the result would spectacular. They're constantly updating the mod and you have almost all races that were ever even named in star trek (the Husnock for example) be playable. Otoh, one could design ships from scrap and equip them with any equipments he/she wants and name it too. This fan production is not endorsed by, sponsored by, nor affiliated with CBS, Paramount Pictures, or any other Star Trek franchise, and is non-commercial and intended for recreational use. I personally made modifications to it, including a more accurate galaxy map, more trek races (like Xindi or Terran Empire), but that game too has problems, especially because there's no true warp travel, moving is done by going through wormholes from one system to another and development is very, very slow. Star Trek and all related marks, logos and characters are solely owned by CBS Studios Inc. Space Empires 4 has a mod which is very close to true trek experience. What is arguably the best Star Trek game available on PC isn’t its own game, it’s actually a huge mod for space strategy game Sins of a Solar Empire: Rebellion. Plenty of mods for BotF, even though that game suffers from bad design. Well, that's pretty much what people making mods did.

Star trek mods for games