Captain Scarlett and her Pirate’s Booty: Fast Travel to Oasis
Mr. Torgue’s Campaign of Carnage: Fast Travel to Badass Crater
Sir Hammerlock’s Big Game Hunt: Fast Travel to Hunter’s Grotto
Tiny Tina’s Assault on Dragons’ Keep: Fast Travel to Unassuming Docks.
The Ultimate Vault Hunter Add-On Packs simply increase the level cap from 50 to 72, combined. You can also complete a gauntlet of sorts at the Digistruct Peak to gain Overpower levels past 72 (enemies/gear will scale up to the 80 range at Overpower 8, the cap, but you will not gain any skill points. Digistruct Peak Challenge must be completed at 72 to unlock Overpower 1, complete on OP1 to unlock OP2, etc.)
There were also “Headhunter” packs where you complete a small chain of quests to unlock a unique head customization; they are as follows:
T.K. Naha’s Bloody Harvest: Fast Travel to Hallowed Hallow
The Horrible Hunger of the Ravenous Wattle Gobbler: Fast Travel to Gluttony Gulch
How Marcus Saved Mercenary Day: Fast Travel to Marcus’ Mercenary Shop
Mad Moxxi and the Wedding Day Massacre: Fast Travel to Rotgut Distillery
Sir Hammerlock vs. the Son of Crawmerax: Fast Travel to Wam Bam Island
As for the rest, it’s all aesthetic changes available automatically in the Quick Change station: a few sets of heads and skins for each character. Plus, of course, the two extra character classes. The Pre-Sequel also has two additional classes.
Borderlands: The Pre-Sequel:
The Holodome Onslaught: Fast Travel to The Holodome
Claptastic Voyage: Fast Travel to Deck 13 1/2