I'd probably have to hand it to Undead Nightmare for RDR1. It felt more like a new game than an expansion of the base game. GTA IV had great dlc's as well. Shame Rockstar will probably never expand their single player games like that again because of GTA Online.
The Souls games all had great...