Having contributed to this thread at the very beginning and then reading through to the end, this is my take (pun intended), so far. I would have to say that although I would, in principle, agree with Daniel, in that the very best of microphones really have no equal when it comes to capturing the true sound of the source, there are very many people, that the choice of microphone, is often secondary when considering the other processes in the recording chain. i.e. the room, the preamp and the type of music being recorded. I don't mean that it's of no importance, just that there may be no other choice but to go with the best mic they have, even though it may not be a perfect match.
Some of us would have one or maybe two mics that are our "go to" selections, and these are made to "make do" on a source that perhaps a mic, with a slightly different response would be better suited. We might purchase a particular, expensive microphone that suits our voice or instrument perfectly, then use that same mic when it comes to recording a different instrument or voice because we don't have any other choice. It's a juggling act. I'm sure the world's top studios would be able to bring out the "perfect" selection for every requirement, but most of us just don't have that luxury, so we compensate with plugins, setups and post production techniques, in order to make the sound as good as possible. Danny is spot on, it's about the music and the other processes. If you can get those right, you can almost always get it so close to perfect that microphone choice is of little to no consequence, and often in heavily instrumented music it becomes almost impossible to tell if a particular microphone has been the perfect choice.
I know in my case, most of my recordings are acoustic instruments with various vocals that are the highlight of the song. As I said in my original post, this is a particularly interesting thread, and as a relative beginner in this situation I am searching for something beyond a Rode NT1, that works great on most sources but is just not suitable for my vocals. I have recorded shoot outs with my collection of Rode NT1, SM58, NT55 and various other low end mics in my collection, and can easily hear the difference between the these, especially in the quiet acoustic numbers. Even though I'm not happy with the recorded sound of the NT1 on my voice, it is certainly preferable to the SM58, though I would not consider using anything else when playing live. I am no vocal talent, I need all the help I can get, so it's important that I find a mic that's going to bring out the tones in my voice that do sound good, it's been done before.
So, I will keep reading threads like these and hope to come across a mic I can try that will give me what I need. It may be even worth trying to hire/loan a mic, and or preamp, that seems suitable, or contacting a studio that has a good selection and paying for some time to do a shoot out with their selection. I know that I won't be spending $4k on a mic on the off chance that it will be the perfect match for my vocals. It's all food for thought.