I'm using a 12 year old servo controlled 80 watt powered Velodyne 10" sub and I have it strtegically placed in the corner (after a lot of trial and error) and it actually had to be turned down a bit. So high wattage is NOT the most important factor in having good home theater bass.
I second the recommendations for "Fifth Element" , "Saving Private Ryan" and "Lord of the Rings" trilogy.
I remember in the first Ring movie whenever they showed the well and when the little biaaatch was coming out of the well after the guy there was a ton of bass, ONLY very low frequencies though, but alot of it none the less.
Resident Evil superbit was also loaded with its share of low end as well. The DTS track did anyways. I can't vouch for the DD track.