For me Ravenholm in Half Life 2 is one of the pinnacles in video gaming from the last 30 years.
The level typifies the classy way that Half Life 2 was constructed and implemented.
There was tension, there was terror and there was the Gravity Gun and some handy buzzsaw blades.