I bet if someone had 100 of each model Neumann U47, U67, and U87, and AKG C414, ELA M 250, RCA type 44 BX and Type 77 in all their variants, EV RE20 in their mic locker, and there was one microphone that cost only $10.00 but delivered the exact sound they needed...
I think... suddenly a million dollars worth of mics is momentarily worthless.
Which makes for an interesting discussion. Just because a mic is of x repute, doesn't necessarily mean it's worth more or less than another.
Obviously, x mic is going to cost more to aquire and maintain, but the soundman or whoever is in charge of dictating the choice of microphones, is going to be the one to place the true value on the mic. Especially if that mic played a productive role for a hit recording.
Also.... who's to say that a cheap oddball mic didn't play role in some very famous hits?
I know of one mic that I have that is just that a cheap puter mic and it produced a sound a near $300 mic couldn't even touch.
So.... with that in mind, mics are like colors of paint. The more colors on your palette, the more colorful the painting can be.
I could be wrong, I usually am. But what the heck, I felt like writing my ignorant two cents for all the world to see.