Cod campaigns are like (most) big budget action movies: Overall enjoyable spectacles if you can turn of your brain for a few hours.
That said, no, I buy CoD once every 3 years (more often than that and I'd get burnt out), and I do play quite a bit of multiplayer. I do play through the campaign though.