The club scene from Hitman (called "Mr Price" in the menu) on Bluray is an amazing scene for gunshots, explosions, etc. One of my absolute favorites for demoing a great action shootout.
As 2x6 mentioned, War of the Worlds is hard to beat as well as there are several scenes that reach deep into the nether-regions of bass.