Check out the E3 Tech Demo for Half Life 2 and the Source Engine

For old times' sake:

Fun to hear the audience's reaction to this incredible tech from over ten years ago.  Still pretty incredible today.