Certainly more common than Michelangelo-level artists! I think the OP's point was that you don't need to be the absolute best in your field, or even that close, to be rewarded handsomely.
There are artist all over instagram that can do anatomy better than Michelangelo. In fact Michelangelo never painted a portrait because he couldn't do it. Leonardo could but Leonardo could not sculpt.
How can you know what goes on in their lives though? Maybe they're bored or bitter or lonely or even suicidal? $500k a year alone does not do much for your well being.
Man, your issue is not that you do not have enough external validation, it's that you crave it so badly. I guarantee you achieving your concrete goals would not make you happy -- you would just move the goalposts.
I would really recommend therapy as a way to understand and reframe the desire for external validation.