This is an important and often overlooked aspect to creativity.
When people get into some thing, they naturally compare themselves to the people out there that are best at that thing. In Ye Olden days before the Internet and social media meant literally the world's best examples of every single thing were right at your fingertips, the "best" often meant "the best in your town" and the level of difference between your novice skill and that was not so great as to be disheartening.
But now, the first day you ever decide to fry an egg, you can watch Gordon Ramsey and Jacques Pépin do it and watch your soul die with the realization that you'll never reach that level. Or you pick up a guitar, then go to YouTube and see some kid who's been practicing twelve hours a day since infancy and lose all hope.
A somewhat perverse trick to combat that is what I think of as low ceilings. If the thing you get into has some limit to how good you can be at it, then the difference between you and the world's best isn't so great that it kills your motivation. I'm an ex-game developer, and I've seen how many people really love PICO-8 and other deliberately constrained game making environments. I think a big part of that is because when you're making a PICO-8 game, you aren't comparing yourself to the world's best games, but just to the best PICO-8 games. Those can be surprisingly impressive too, but they don't feel so unattainably distant from your own first steps.
If you don't want to choose a medium that is instrinsically limited, another approach is to find a scene. Find a group of like-minded individuals at roughly the same skill level as you. Enough better than you to inspire you, but not so far that you don't feel you could ever reach their level. Immerse yourself in that group, an you'll naturally compare yourself to them and not the world at large.
Back when I used to be in a band, we played shows in small venues with other local bands. I knew we were never going to be the next Oasis or Tom Petty, but "Orlando's third-best rock band" was close enough within reach to be worth striving for, and it really helped keep me going.