Another option is to specialize to a very large degree. It's possible for almost anyone (assuming sufficient motivation) to become a leading expert in a field or the one of the best at some activity, as long as it's sufficiently niche. You may have to go in a subfield of a subfield of a subfield in many cases, but it's much more realistic to be in the top 10 of something with just a few hundred practitioners than something with a few million.

Take music, becoming one of the top 100 pop musicians on the planet in terms of popularity is incredibly unlikely, but top 100 of some more obscure genre (such as synthwave) is more achievable. You can add more qualifiers - (e.g. Italo-disco inspired synthwave) until you feel comfortable with the pool of competitors, and you'll be far less at risk of feeling insignificant and overshadowed.