The only CoD games I didn't like were Modern Warfare 2, Black Ops, and Ghosts. Even then, I don't play much of multiplayer or the campaign. I prefer Zombies over the actual game themselves but it is fun to play multiplayer when you're with friends and if there aren't idiot children on the mic saying crap like "420 GET REKT FAG LOLOLOL". But the campaigns for BO2 and Modern Warfare(and games earlier) were really good.
That said, Black Ops 3 had two really good trailers. If the game is as good as the trailer, then I'm sure it'll be great. The zombies, not so much. Zombies started getting way too complicated after Black Ops zombies. Black Ops has the best zombie maps(IN MY OWN OPINION).