The more you spend, naturally the quality becomes better but that nessasarily does not mean its guaranteed to sound amazing on all things.
Well thats a statement I classify under "audiosnobism", there's no such thing as a 'better mic' once you go around 1000 - 2000$, even an SM57 can outpreform a mic 50x its price! It depends! It's all about different flavours.
Like u said, its not guaranteed to sound amazing on all things, and thats a strong 'but'. Recently I had a vintage C12 in the studio, and a collegue strongly wanted to record with it cause, well it's vintage and expensive!
Turned out we lost an hour on the damn thing, and ended up using my modded Oktava (300$), wich just worked well!
Go for the most versatile mic u can afford, NOT the most expensive.
I saw akg c414 in here somewhere? Well thats a good start imo.