I guess I just don't understand what cheesey cut scenes and a contrived story are supposed to add to the game play.
If you want tougher competition that's actually capable of real strategy, log onto Ironclad Online and play against real people. If you want variety to your Sins game explore the numerous catalog of custom maps and mods, or learn to master the Map Designer if you don't want to make maps in Galaxy Forge. If you want a science fiction story, go read some good sci-fi, which will be much better than anything a game studio could work up. I do wonder, though, what exactly are people hoping to get from a campaign? People seemed to like Civilization and Alpha Centauri without their having campaigns.
Maybe if it felt like it had the story-telling aspect of an RPG while remaining a 4x-RTS. So many people have clamored for this, I hope the can figure out a way to do it 'their way'.