I just wanted to give special mention to the misty mountains in Skyrim, Bethesda really did an amazing job with them.

They may be the single most impressive thing visually I've seen in any game!

Props

Is this a place called 'The Misty Mountains' or are you just talking about the awesome fog effects around mountains and water?