Two recent ones stick out in my mind:
From Braid, the world where when you walk to the right, times goes forward and when you walk to the left time goes backwards. It's amazing just how perfectly those levels are planned out.
From Left4Dead: The hospital level. The atmosphere in that level is amazing, especially when you get on the top floors. I almost crapped my pants the first time a zombie came through the wall.








