But there have been successfull ones like startrek Armada ect
That is true, but even that game failed in some respects, especially when it comes to balance, multiplayer and some of the features (ships or races that showed up in game but not buildable by player, like Galaxy class).
The best Star Trek games were the ones that basically came as fan modifications, mods for BotF and SE4.
I quite agree!
Thats why if a good indi devloper got the startrek lience and publishing support they could no wonders.
Look at games like X3 terrain conflict, stardrive, galatc civ2. They have done amazing things with little to no money or support!