Ruins of Kunark. It was the first Everquest expansion which improved the game in every way.
Dungeons of Norrath is my second favorite for adding procedurally generated dungeons with a whole new upgrade path to pursue.
For non MMORPG it has to be Baldur's Gate: Tales of the Sword Coast.