Do you have some anecdotes to share regarding this?
[1] https://jacquesmattheij.com/sorting-two-metric-tons-of-lego/
But there's another way forward, combining good skills that are greater together. Here's an example of a hypothetical set of skills that can lead to a life-changing amount of fame and financial success.
* Maybe you're not among the best cinematographers in the world, but you know your way around a camera, lighting, and video editing software enough to create a reasonably polished video. Your videos are not Hollywood good, but your ability to create a good looking video is in the top 10% of the population.
* Maybe you're not the absolute funniest, best-looking, and most charismatic person in the world, but you've worked on yourself a bit and are noticeably more appealing than an average person, maybe in the top 15-20% of the population.
* Maybe you're not the absolute smartest person when it comes to computers, but you've built a few gaming PCs, took some Computer Science courses in college, read some blogs and forums, and spend some of your free time following the industry. You might be in the top 10% of the general population when it comes to general computer knowledge.
By itself, none of those skills are remarkable in the slightest. You're never going to get a job setting up special effects shots for Michael Bay, no agent is going to notice you at Starbucks and give you a contract as a model or actor, and Tim Cook isn't going to ever call you at 2 AM begging for your help with emergency fixes to some web service. But you put those 3 things together in the right way, and you can be a successful Technology YouTuber that has a mass following and influences the computer industry to some extent.
I'd think Kanye is a good example of somebody well-known to look at in terms of a list of talents that are good, but not anywhere close to the best. I'd argue that by music and fashion industry standards, he's nowhere close to the best singer, lyricist, dancer, businessman, or designer in the world. But he has a lot of skills that are all above average when compared to the general population. That's enough to be incredibly successful when combined with his self-promotional ability, risk-taking, desire to increase his knowledge, stubbornness, self-confidence, and charisma.