Songs with great drums
+1 on Meshuggah - try "The Demon's name is Surveillance" off Koloss, the guy is half machine half maniac!
Foo Fighters - My Hero
Green Day - Basket Case
Faith No More - Epic
Queens Of The Stone Age (Dave Grohl) - No One Knows [live version, Glasto' 2002 
]
The Who (Keith Moon) - Won't Get Fooled Again
Jacques Loussier Trio (André Arpino) - Fugue No.5 in D major
Jacques Loussier Trio (André Arpino) - Fugue No.5 in D major
Good to see this in the mix......great stuff!
Small correction: not just the first song, but the complete album. I think Neil Peart really outdone himself with this one.
An Englishman in New York, Sting.
Cassandra Wilson - Dance to the drum again .
Amazingly powerful deep drum that sounds and feels like thunder rolling in the distance 
There are many amazing suggestions here worthy of greatness.
A few of my personal favourites I'd like to get a mention as much for groove as well as technical excellence:
Iron Maiden -Run to the Hills (love around the kit drum rolls)
Safri Duo - Played a Live the Bongo Song
Ac/Dc - Thunderstruck/ Heatseeker (make that everything by Ac/Dc )
ZZ Top - Gimme all your loving
Ozzy Osbourne - No More Tears
Faith no more - Stripsearch
Fear Factory - Demanufacture
Korn - Freak on a leash (Boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema Da boom na da mmm dum na ema?
Life of Agony- Through and Through
Machine Head - Davidian
Queensryche - Eyes of a Stranger
Strapping Young Lad - Detox
Primus - Wynona's Big Brown Beaver
Judas Priest - Painkiller
Pantera - Primal Concrete Sledge
Sepultura - Refuse/Resist/Territory
Slayer South of Heaven
System of a Down - Sugar
Carcass - Heartwork
Morbid Angel - God of Emptiness
Fleshgod Apocalypse -The Egoism/ The violation (Just incredible)
Sorry my list could go on and on, sometimes wish I hadn't decided to hang up my stix. Actually this would make a good demo disc for searching for new equipment, at least you would have the shop to yourself.
Eva Cassidy - The Letter
Gary Boyle - Grumble
Mac Pro - Rega DAC - Electrocompaniet ECI5 MK1 - Dynaudio Focus 110 - Good Music - Big Smile