Man, do you guys actually *like* plug-in compressors on drums?? I really have yet to find anything in plug-in compressor land that I can use and feel good about.
If you ever get the chance, try renting a couple of cool outboard comp's and running your DAW drums thru 'em. I guarantee you, it will be an eye-opener if nothing else. A couple of Distressors will absolutely *kill* any plug-in you have ever heard.
Anyway... Jon is right, OH and room mics are 90% of your snare sound. Dunno about you guys, but sometimes I squash the snare mic HARD, until the initial attack spike is all that gets through the compressor. Then, start bringing up the OH's and room until you get something cool, and bus compress it together with the dry snare and kick mics. I've gotten some of my coolest drum sounds by pushing those bus compressors beyond any sane limit, until they are pumping like crazy and you get that massive sucking sound from the room. Bonham city! Try lots of mults, too. I like to bus all the drums together, smashing that and then blending it back in to the 2-bus. Maybe it's just me, but I really dig 'lo-fi' analog compressors for that type of thing. Joe Meek's, UREI's and Distressors are all yummy.
OK, in plug-in land I have actually found some use for the Waves RenComp and Metric Halo ChannelStrip. CS is nice cuz you get gating and sidechain limiting all in one plug, useful for all kinds of "trouble" drum situations. The gate on CS is actually pretty cool for mangling some things. RenComp is probably my favorite all-around software comp right now, and I will definitely use it in a pinch... but man, given the choice, I'll use outboard analog stuff any day.
Good luck!