The "story" was typical Black Ops, this 80s spy stuff. My big problem was that it really lacked a lot of action. There were some stealth elements to it which were... fine? It just felt wrong in a COD game. Basically there's a few main missions and some side story missions, that all combined are a whole lot of cut scenes and not a lot of action. I mean, I didn't hate it, but spending more than $20 on it would be a mistake. There's really only a few hours of content in there. I enjoyed MW even though it was very short. This would just be a big waste for $60-70 without getting into MP.
Zombies is ok, the big issue is that leveling up guns in MP is super slow, so everyone farms XP in zombies (and quits in the later rounds). I've never been a huge zombies fan, and honestly it feels sort of cookie cutter. Either you have competent teammates who do the right thing, or you don't.