I agree both SP and multi should be good. I felt so horribly ripped off when I bought Battlefeild 3, the campain was just the same respun crap from previose ones, oh and it only lasted like 3-4 hours? WTH?
I found the story in SP Black Ops 2 only marginally better. One high mark is the ability to travel off the main path and do side quests. No other BF or CoD games has that. A FPS shooter with side missions and custom load outs for the SP mission, excellent. They do not get enough credit for that IMO.
However, I felt the SP was tailored to the ADHD teenage generation, but then again its CoD.