All drummers have a great sound as long as it is unique for them
My favourites are
Peter Erskine for jazz
Chris Adler for metal(great kick sound, toms tuned a little bit too low though)
There are many others- Joey has a nice sound, Weckl has na wery fat sound on his regular set, Stanton Moore has veeery nice funky sound (snare is the best) etc etc.
Just so you know, any album that has been recorded in the last 10 years is probably triggered. So what you hear is a mix between the actual drum and the trigger. Very few albums have natural drums anymore.
Gary James of Thunder on the Laughing on Judgement Day Album (their 2nd) . Which was recorded way back in 1990(ish) The tones and sound coming off the kit on "Low Life In High Places" is superb. I reccomend to all of you to search for that song as it sounds to me that there is nothing more than a bit of reverb on that kit when it was recorded.
Taylor Hawkins - Foo Fighters "Colour and The Shape"
Tre Cool - Green Day "Insomniac"
Lars Ulrich - Metallica "Black Album"
Vinnie Paul - Everything Pantera Has Ever Done!
Dave Buckner - Papa Roach "Infest"
Also: I feel like it doesn't matter whether or not the drum sounds on an album are triggered or not. If they sound good, they sound good. Obviously, acoustic, untriggered drum sounds are ideal, but c'mon... Unless you're signed to a major label and have a ridiculous budget, that's not gonna happen.