Damnit, everyone already mentioned all the good stuff (Phendrana, DKC, Uncharted...)
Umm... the snow maps in StarCraft? That one town in Tales of Symphonia? The Thing? Some of the spec ops missions in Modern Warfare?
--
Your Life *SPOILERS!* -- The main character dies at the end.