Rather than mistakenly believe that one kind of mic is better or worse than another, we’d suggest reframing your creative expectations. The truth is that all mics - dynamic, condenser, large-diaphragm, small-diaphragm and so on - will colour or affect your sound to some extent. On the face of it, this trait may seem undesirable but it can reveal huge creative opportunities.
Consider the sound you are trying to achieve and then think of a mic as an instrument that will help you to realise it. Different mics and different applications will yield different results. Not necessarily better or worse, just different.
This explains why pro studios have a legion of different microphones at their disposal, and why so many producers, engineers and artists favour particular models to reproduce their signature sounds. It also helps us to make sense of the huge variety of condenser mics on the market, and narrow our choice down to the model or models that will best fit our sonic ambitions.