Here are some of mine:
Hitman Blood Money - A Dance with the Devil level
Chrono Cross beach:
The beginning of Thailand in Tomb Raider Underworld:
The Happiness stage in SSX3:
Deus Ex (2000) - a game that pushes the boundaries of what the video game medium is capable of to a degree unmatched to this very day.