Campaign: I liked this campaign, it had a variety of missions, the story was pretty good, but I kinda hate its ending (don't want to spoil it for you).
Multiplayer: Never cared about the multiplayer part of CoD (or the term is PvP, I think), but I find that Squads is the multiplayer experience I've been looking for. Players teaming up against AI bots. Safeguard is pretty much a race to get Sleight of Hand, Faster Health Regen, Sentry Guns, and Vultures. It's fun, but without teamwork, it's hard to complete. We also get offline multiplayer again, which is always a plus. I would rather fight bots then fight kids and childish people who tell me how they slept with my mom last night or something, since I suck at playing against other people. (Tip: Stormfront is the easiest place to beat Safeguard in my opinion)
Extinction: I enjoy it, since it usually requires strategies with both the maps and the loadouts in order to complete it. It is about as replayable as Zombies, although it depends on how much you really like Extinction. I enjoy killing aliens, except Rhinos. It will require as much teamwork to completing the Extinction map as completing a Zombies easter egg, at least to me whenever I play with random people.
DLC: Standard 4 multiplayer maps and a new Extinction map, although the Ripper looks like a sweet weapon, being able to be a sub-machine gun and an assault rifle in one weapon. Again, replayability depends on how interested you are in Ghosts. Oh, and so far, they've been adding multiplayer guns, just like how Black Ops 2's first DLC came with that one submachine gun, I forgot its name...
I would recommend this to you, since the campaign is good, there is offline multiplayer, and Extinction is pretty fun, but again, it's about how interested you are in Ghosts overall. I submitted to my inner CoD fanboy in me and got it, and I haven't been disappointed in it.