Pretty much every area from Tiny Tina's DLC is great. I wouldn't say Borderlands 2 is the best open-world game for locations (I can generally summarise them as the ice level, the sand level, etc.) but I enjoyed them. Maybe the art style has something to do with it.