Here are a few mics some executives cringe at when I pull them out of my mic locker to use:
AKG 414 on voice-over. One of the mixers I apprenticed under hates this mic for some reason. I use it as a secret weapon against loud Castilian and Latam voice-overs. The "ah" factor is seriously reduced compared to a U87. I think it has something to do with the off-axis response - it's pretty dead in the back.
AKG C5 with it's grill unscrewed. I use this mic with the top foam grill of it taken off. I get it pretty close to the source and it's wonderful. It, too, has an extreme attenuation in the off-axis response and in a review I read about it, the only way the person was able to make it feed back in a live situation was to hold the capsule directly towards the bell of the speaker.
A 10-inch speaker modified to be a kick drum mic. I use this in combination with 2 other kick drum mics. The speaker adds this extreme low-end slump (25-50 Hz). It makes it full. I learned this from the music mixer I work with now.
Shure SM7. I held in my hands the same mic as was used to record the vocals on Thriller and asked Bruce what his favorite VO mic was and his reply was the SM7 that I was holding. This is also what he used on Vincent Price for the song. I am unsure what the difference is between a SM7 and an SM7B, but Bruce's sounded absolutely fantastic on a voice. You must make sure you have a quiet pre-amp to use it with, though, because you have to boost it quite a bit to get any sort of level out of it. Rumor has it that this is the mic used on the lead singer of Red Hot Chili Peppers and Metallica.
Mojave mics. Specifically the pencil-condenser ones (I'm unsure what model though - was a while back and we only had demo ones). I thought these sounded lovely on a grand piano. On a voice they held their own against an MK41 and MKH50.
Sanken COS-11 as a voice-over mic. Just mounting it on a mic stand and placing it about 6 inches from the actor's mouth sounded pretty darn good considering it's a lapel. Try it - you might be surprised.
Telefunken M-80. This mic was touted as being the "SM57 Killer". That hasn't happened yet, but the mixer I am working with got a prototype as a gift and we use it on snare, guitar cabinets, etc. getting a wonderful sound.
I'm not surprised you like the sound of the 4050. I record the voice of E! in Italian and he told me that the engineer over at E! replaced out every single studio that had a U87 for recording dubbing voice-overs for that station for 4050s a long time ago. It's a great mic.
Studio Projects C-1.
If I think of more I'll update my answer.