So, I actually made up a campaign on the GalCiv Editor, and it is called Borg Apocalypse. As the title suggests, you are fighting against the Borg. You get to choose from 5 empires; the Federation, the Klingons, the Romulans, the Cardassians, or the Ferangi. And then there are a bunch of minor races (e.g. Vulcans, Breen confederacy, etc). While political alliances may shift from time to time, everybody is at war with the Borg.I might post the scenario for download later, after I work out the kinks.
I made the Borg almost God-like in this campaign; that is, they have all the techs all researched already, all the best weapons, all the best construction projects, etc. The rest of the races, on the other hand, are not, some are a little more advanced than the others, although all of them have phasor technology by this time. Personally, I think I made the Borg a little too strong, as you will soon see...
All ship designs for each species are there, with the Federation having the iconic USS-Enterprise D. With the story line, I made a little alternative Star Trek history here, as when the game begins, the Klingons and the Romulans are at war with each other (there are no locked alliances however), the Federation will have to deal with corruption issues and ridding itself of Romulan spies, the Ferangi are only concerned with profit and as such their military weaponry won't be as developed, and the Cardassian empire, while having the same techs as the Federation, will not have a very large fleet and the smallest empire of them all.
The Borg start of with 6 ships; 2 Borg Cubes, a Borg Sphere and 2 armed transports. At the beginning your weapons will be far too inadequate to take them out unless you have a large enough fleet. But of course, you won't know where they will begin, nor will you actually have the organization necessary to mount such an attack (after all, you have your own domestic problems to worry about, not to mention hostile aliens).
So anyways, here are the rest of the maps specifications:
Tech rate: Very Slow (By game design, you are not supposed to be able to catch up with the Borg).
Map Size: Gigantic (To give a little time to set up defenses before they come crashing in)
# of Major Races: 5
# of Minor Races: 12 (Some can aggressively colonize, heads up)
Condition for Victory: Defeat the Borg.
And so, now we begin this tragic tale......