to echo Harvey's points in another way........the answer for me is "it depends on what kind of drum sound i'm going for". i use both (or either) all the time. sometimes i want the accuracy of the SDCs (which respond more quickly) and sometimes i want the flattery of the LDC.
with SDCs, though, i tend to go with omnis rather than cardiods.
with LDCs, instead of going up above the drummer's head and looking down, i tend to mic the kit from above and slightly in front, facing back towards the drummer. sometimes, though, i'll mic the kit from behind.
sometimes i'll do a spaced pair of SDCs (wide L and R) and a mono LDC in the middle.
the real meat of my drum sound, though, typically comes from the mono "front of kit" mic.......about 6ft in front of the kit, usually about 4ft high.
it's a lot like vocals--the same drum micing setup isn't going to work for every single song. some songs will need all the toms to be miked, some songs will require little more than a kick, snare and mono overhead.
cheers,
wade