Map Pack 2 has 3 distinct multiplayer maps, which all have a unique look to them and you'll likely enjoy if you're a fan of the multiplayer (none of these maps support vehicles, I believe).
The biggest star of this map pack is the new Nazi Zombies map though, which feature four amusing soldiers representing the major countries of the game (Japan, Russia, USA, Germany). The four soldiers give some funny banter to one another when you perform certain actions, doing more than what the previous maps have done.
Also, there are the Hell Hounds, which a giant, ghost-like dogs that appear and charge at you during certain waves. For $10, the new maps do extend the game and take it interesting directions. At the very least, it makes me hopeful that Treyarch will take some of humor and horror of the Nazi Zombies mode and implement them in a new, standalone project.