I actually like the thread topic, so I'll contribute.
The Dwemer ruins in Morrowind were pretty good. A lot of the dungeons in Morrowind, even the generic caves, had pretty nice atmosphere. But the loud ambiance of steam pipes and gears clanging in the walls combined with the low artificial lighting made them feel cozy, unnatural, and threatening all at once.