Civ IV has a "Final Frontier" module to the game which has been ported to a Star Trek Mod. However, I am not thrilled with it at all. That's mostly because of the way the Civ Combat system is set up. One unit with a significantly high enough strength, Say a Borg Cube, would be invincible because it would take a hundred ships just to scratch it. The Combat system only allows for one unit to attack at a time, which makes masses of fleets worthless for offense.
The combat system works something like this (with some arbitrary numbers added in)
Borg Cube: Strength 100
Federation Galaxy: Strength 12
100 + 12 = 112
Random Number between 1 and 112
If Random number is less than 100, Borg Cube hits, if Random number is greater than 100 Galaxy hits
Infinite # Galaxy Class ships attack Borg Cube.
First fight
Borg Cube hits Galaxy 1 for 100 damage. Galaxy 1 destroyed
Second fight
Borg Cube hits Galaxy 2 for 100 damage. Galaxy 2 Destroyed
Third Fight
Borg Cube hits Galaxy 3 for 100 damage. Galaxy 3 Destroyed
Fourth Fight
Borg Cube hits Galaxy 4 for 100 damage. Galaxy 4 destroyed
Fifth Fight
Borg Cube hits Galaxy 5 for 100 damage. Galaxy 5 destroyed
Sixth Fight
Borg Cube hits Galaxy 6 for 100 damage. Galaxy 6 destroyed
Seventh Fight
Borg Cube hits Galaxy 7 for 100 damage. Galaxy 7 destroyed
Eighth Fight
Borg Cube hits Galaxy 8 for 100 damage. Galaxy 8 destroyed
Ninth Fight
Borg Cube hits Galaxy 9 for 100 damage. Galaxy 9 destroyed
10
11
12
thirteenth fight
Galaxy 13 hits Borg cube for 12 damage (88/100)
Borg Cube hits Galaxy 13 for 100 damage. Galaxy 13 destroyed
Seventeenth Fight...
Borg Cube hits Galaxy 17 for 88 damage. (12/100)
Galaxy 17 hits Borg Cube for 12 damage. (76/100)
Borg Cube hits Galaxy 17 for 88 damage. Galaxy 17 destroyed
Twentieth Fight...
Borg Cube hits Galaxy 20 for 76 damage. (24/100)
Galaxy 20 hits Borg Cube for 12 damage. (64/100)
Borg Cube hits Galaxy 20 for 76 damage. Galaxy 20 destroyed
Twenty-first Fight...
Borg Cube hits Galaxy 21 for 64 damage. (36/100)
Galaxy 21 hits Borg Cube for 12 damage. (52/100)
Borg Cube hits Galaxy 21 for 64 damage. Galaxy 21 destroyed
Twenty-sixth Fight...
Galaxy 26 hits Borg Cube for 12 damage. (40/100)
Borg Cube hits Galaxy 26 for 52 damage. (48/100)
Borg Cube hits Galaxy 26 for 52 damage. Galaxy 26 destroyed
twenty seventh Fight...
Borg Cube hits Galaxy 27 for 40 damage. (60/100)
Galaxy 27 hits Borg Cube for 12 damage. (28/100)
Borg Cube hits Galaxy 27 for 40 damage. (20/100)
Borg Cube hits Galaxy 27 for 40 damage. Galaxy 27 destroyed
twenty eighth fight
Borg Cube hits Galaxy 28 for 28 damage. (72/100)
Borg Cube hits Galaxy 28 for 28 damage. (44/100)
Borg Cube hits Galaxy 28 for 28 damage. (16/100)
Galaxy 28 hits Borg Cube for 12 damage. (16/100)
Borg Cube hits Galaxy 28 for 28 damage. Galaxy 28 destroyed
Twenty ninth fight... its almost dead!
Galaxy 29 hits Borg Cube for 12 damage. (4/100)
Borg Cube hits Galaxy 29 for 16 damage. (84/100)
Borg Cube hits Galaxy 29 for 16 damage. (68/100)
Borg Cube hits Galaxy 29 for 16 damage. (52/100)
Borg Cube hits Galaxy 29 for 16 damage. (36/100)
Borg Cube hits Galaxy 29 for 16 damage. (20/100)
Borg Cube hits Galaxy 29 for 16 damage. (4/100)
Borg Cube hits Galaxy 29 for 16 damage. Galaxy 29 destroyed.
Thirtieth Fight. (Ok I'm as surprised as you that Galaxy 29 didn't finish it...)
lol! Borg Cube hits Galaxy 30 for 4 damage. (96/100)
Galaxy 30 hits Borg Cube for 12 damage. Borg Cube destroyed (Finally!)
Ok that was a bit excessive, I apologize, but I randomized everything as I was posting, and what you got, was a typical fight between two players ( or between a player and a computer on Warlord, anything higher and the computer will cheat in its favor) You might argue that that is what SHOULD happen. And I agree in that instance it should happen. However, imagine a Starbase assault. Starbases have to be significantly powerful enough that that own their sector, but a determined fleet can take it down. Well since each battle is one at a time, you can imagine that it may take a significant force to kill a starbase, and even then your taking heavy losses, where as if you had a significant force in a SFB fight, how many of that force is actually going to be destroyed if they are all firing their weapons at once?