I've had the best luck with the Beta 52 and the D6. I also second the notion that tuning counts for so much.
I had a post on the LAB that went over my drum mic experience. The most important thing I've found is that different drums sound better through different mics. Sure, the B52 and the D6 will do well in more instances than the others in my opinion, but you just never know. For my current gig, I've tried just about everything (91, Beta 52, D6, D112, RE20, 421, Sennheiser e602, Beyer M88, AE25000) and his drum really sounds best through a lone Beta 52. I've got another friend who's drum sounds strange through the 52 and awesome through an M88.
So, in the end, my opinion is if you're a venue or a PA company: Beta 52 or D6. If you're working with a specific artist: try as many as you can!