What makes a great single player campaign in a FPS game?

[curl-6]

TheKoreanGuy said:

 

One of my most favorite FPS campaigns ever and this was probably the best mission of them all.

 I honestly never got why people so adore that mission. So much of it was just boring padding to me.