For me unless you're recording in a great live room on a great system with great D/A-A/D, great preamps, and great monitoring then there isn't a huge amount to be gained from posher microphones - the benefit will only be as great as the weakest part of your recording chain.
I'd strongly disagree. The weakest points in most recording chains are the transducers - the mics and monitors. Digital recording and electronic advances mean that everything in between is much better than it was only 30 years ago.
I've happily used U47's and U87's with Behringer mic amps and their qualities still shine through. On the other hand, like Mike, I've been extremely impressed with the Yoga tom mics on the odd occasion that I've used them. I've also been impressed with certain electret capsules that I've rescued from old cassette recorders although this can be a bit hit and miss as others have been a bit rubbish.
One other classic mentioned by Elf elsewhere is the Tandy PZM. Rumours abounded that it was actually made by Crown butit looks more like a cheap imitation to me.
JRP Music - Audio Mastering and Restoration.