I think my favourite would be the Ancient Cistern, I absolutely love the heaven and hell concept of it: The top area of the dungeon feels like you're outside and actually has quite a nice grand feeling about it. That completely changes when you reach the bottom and you can hear the dead bodies...