The multiplayer has quite a bit of depth and the ranking system is good. The MP system can be a bit buggy, though, so beware.
I haven't beat the single player yet, but it is beautiful and well done. Some great story telling and scripting going on.
The graphics are the best I've ever seen in a RTS, bar none. The destructible enviroments are cool, and everything is very destructible. Audio is excellent.
I have the CE edition, and aside from the cool case it isn't really worth it. But if you like cool cases, go for it.