Here's what I can think of at the moment. I have dug up some links to where you can hear it too.
1. Mary Margaret O'Hara - Year in song (Michael Sloski: drums)
http://www.youtube.com/watch?v=i35mAvFY7pw&fmt=18
I have always loved the sound and playing in this song. Very groovy. Awesome snare. Theres a bit of room ambience in the sound.
2. Siouxsie & the Banshees - Little Sister (drums: Budgie)
http://tinysong.com/7jQx
Incredible song.The sound of the drums...wow. Budgie is an awesome drummer.
3. Simon Phillips - Red Rocks (drums: Simon Phillips)
http://tinysong.com/alKE
The songs on his first album are nice, the drawback is that all instrumemnts except drums are synth sounds, so it's a bit mechanic. But the drums and playing is terrific. I love this snare sound and the way it's recorded. I also love the hi-hat and everything else.
I was really lucky that I found this song so you can hear it.Simon Phillips is my biggest influence, I have to say.
4. Saga - The Victim (drums: Steve Negus)
http://www.amazon.com/The-Victim/dp/B0017YR4E8/ref=sr_1_19?ie=UTF8&qid=1253920793&sr=1-19
I only found a sample.This song is very groovy. I haven't thought of the snare particularly before, I just like the overall sound of everything. But it's a nice snare sound. Steve Negus is another favourite of mine.
5. This Ascension - Alex Kidd (drums: I don't know)
http://www.amazon.com/gp/product/B001DZ2Z0O/ref=dm_mu_dp_trk4
Just a sample. The drummer isn't remarkable, but I came to think of this album since I've been fond of the sound of the snare on it. There's quite a bit of room ambience to the drums.
If you liked the Red Rocks song, you should also like Slofunk from the same album:
http://tinysong.com/alL3
Have fun listening.