Another vote for The Fragile. That album goes lower and louder than any other non-hiphop/rap album in my collection. Tracks 8 and 10 off the first disc alone will get you kicked out of most apartment complexes.

The other NIN albums aren't bad either. If you don't mind rap, I'm partial to Paul's Boutique by the Beastie Boys, myself. I'd love to hear Shake your rump through an SVS!
Btw, maybe it's just my setup, but The Brazilian by Genesis doesn't have much low-end impact to me. Not to mention 'Front By Front' by Front 242, I don't really hear much low bass in that album either. Although the album 'Off' is no slouch.