I've played it and I think it's pretty good, wish I could say the same for the acting but meh, can't have it all in a game! The best campaign is the NOD compaign, much more fun being evil than good hehe. Plus you have that guy from lost working with ya!
The gameplay is pretty good I think, although unless you're using hard mode the levels aren't that hard to complete compared to previous C&C games.