There's no "best drum mic", since most of them perform their tasks quite good, and mostly it depends on the kick drum.
Here's my take:
Personally, I'm not really fond of
Audix D6, first of all - it's voiced too much and makes a lot of bass drums sound the same, and it's biggest flaw is - it will break down and die. Although it does sound quite good and gets the job done
Beta 52 IMHO sound much more detailed than D6, while being in the same ball park.
Sennheiser E602 - I worked with that one a lot, and I don't really like it, boomy low end, with mushy lowmids, can't really say it would be my go to mike.
AKG D112 - has strong midrange (1 to 3khz) which might not sound right with some kick drums, you can eq it out, though, I like the D112, it's not too modern and works well outside of the bass drum for more acoustic sound, and if you put in the kick drum, you can tailor it to have more highs and more modern sounding.
AKD D12VR - that one has switches and stuff, but it sounds great, quite punchy!
Shure Beta 91 - I like the limited dynamics of this microphone - makes crappy drummers sound less crappy. The microphone is prone to failure in the end, a big minus, I would never buy it.
Sennheiser E901 - similar microphone to Beta 91, but with softer high end, will not die on you like the Beta 91, useful outside of metal genre too.
EV RE20 - this one belongs in the 70s, no real use today, unless you like boxy sounding lowmids and you're doing jazz... Too much eq needed to get rid of the lowmids, if you want acoustic stuff, try D112
The Audix F6 is not bad, if you want something on the budget, quite similar to D6, but cheaper - much better mic than PG52 or similar low grade kick microphones.
I currently use D112 for touring, but if somebody gave me Beta 52, I would probably use it better than the D112. Wish Beta 91 was more reliable... Maybe the newer Beta 91A is sturdier?
I have limited experiences with E902, so I cannot comment on that one, also there's that Audio Technica kick mic that is both dynamic and condenser, I think it's AT2500, that is a really good kick mic, but I think it costs 2x the usual mic (D112, Beta52).
Can anybody comment on Heil kick mics? Are they reliable? Are they similar to Beta 52? Some other?