You guys should probably try playing Supreme Commander a little

In Supreme Commander you essentially had three "types" of end-game super-weapons to break ties. First off was the nuke launcher, which fired nukes (that had a horrible build time and cost) which could be shot down if you had an anti-nuke close enough to its target.
Second was the T4 "super robot" which could wipe out a lot of T3 units, but had weaknesses of its own (usually in the form of T3 aircraft, specifically strategic bombers, for the land ones) but could also be taken down by just spamming lesser units at it. But if properly supported, the T4 unit could turn the tide of battle pretty effectively.
Second was the long range artillery, that could shell a base from a long distance away. The only real counter was to destroy it, ASAP, though it did have its weaknesses. Spamming heavy shield generators would allow you to absorb its fire (more or less), and while it did a fair bit of damage its long reload time and minor inaccuracy (depending on race!) meant that it wasn't an instant game-winner, like a nuke. That said, a battery of several T3 base Arty's would general do a
lot of damage to an unsuspecting opponent who forgot to scout(edit: That was true of all three, in fact... scouting the enemy base + having a couple dozen strategic fighters in reserve at all times was pretty much a necessity).
I was thinking the same thing. Supreme Commander managed to do the whole "super weapon" thing perfectly. I think the thing we're not realizing is that some of the sides do have super weapons, we just don't know what they are. The Vasari have planet eating weapons and a huge cruiser right? I could be off on that though. I think if this thread wants to be constructive though, we should start tossing out super weapon ideas.
I imagine it would make the most sense if each race had it's own unique type of super weapon. The Vasari have the planet sucking up thing, the psychic mind dudes have some giant capital ship, and the TEC can have a special ship that carries a true nuclear weapon on board, you know, one that wipes out ten capital ships at once.
I love nuclear explosions.