Pros:

-Great Story
-Nice looking levels
-Balanced challenges.

Cons:

-None that I can think of.

Conclusion:

This campaign could have been in the game to start with, it is by far the best custom one I have played thus far!