I'm playing Uncharted 3 now and the ship stage is amazing! Another one of my favorites is the train stage from Uncharted 2. Some of the best level designs ever. Thank you Naughty Dog. Thank you Sony.

What are some of your favorites?

Every single level in Deus Ex.

Valve usually do pretty good level design, though they do make some very illogical choices too.