well, with drums, there are a couple issues here.....mainly bleed and off-axis rejection. the sm57 has a pretty nasty sounding off-axis rejection, which can make close-micing drums with them pretty sketchy. the nasty off-axis sounds will negatively color the otherwise good sounding "on axis" (intended) sound. this could be interpreted as "excessive bleed" to the untrained ear.
when i mic drums, i aim for the majority of my drum sound to come from the overheads (and/or room mics), kick mic, and snare mic. i mic the toms as well, but i gate those mics and often don't use them. sometimes i'll gate the snare and kick mic too, but often that does more harm than good. if you can get the kit sounding good on its own in the room, then you don't need a plethora of close mics.
anyway, yes, super cardioid *may* help focus the mic better on the source.....but oftentimes super cardiod mics have a worse sounding off-axis pickup. i'd look for mics that "sound better from around back and to the sides", more so than tighter patterns....but that's just me. i don't tend to rely on close mics much, though......so take this FWIW......YMMV.....
cheers,
wade