This game will rock your world. There literally is NOTHING like it.
However, I liked the Single Missions, but HATED the campaign - they really do highlight the difficulty with play balancing a dynamic and reactive game.
As for the Multiplayer, so far I've managed to keep a team of 8 guys happy at work with a couple of custom missions. As my skill improves with the editor - the scripting I find hard, but others seem to have grasped it easily enough - it will get even easier to produce decent missions.
The netcode improvements will be welcome - especially the idea of a stand alone server. But as I say, I've had all my fun with the pre-patch version.
Do yourselves a favour and DON'T miss this game.