I like to remember that even the greats made a whole lot of content that was never published that people never read or think about. Like I was doing this epic long comic in college, and my teacher was like "whatever you're working on is not your magnum opus" and I was really offended at first because I thought my project was amazing but what he meant was 1.) I had some rose colored glasses on because it was a project I was clinging to from my youth and 2.) I'm going to be making lot of work in my lifetime, so I shouldn't let any one project consume me.
And what I learned is that I had to put the project away when my skill couldn't reach what I wanted the story to potentially be, and in the meantime just worked on several different stories to improve my skillsets. And, in the process, sometimes those stories clicked with different people. Not many people--I've never done anything famous, but like, I did a fancomic years ago that was so bad because I had carpal tunnel when I drew it, it only had like 30 followers, and years after I made it, I got this sweet message from someone being like "this is my favorite comic, when are you going to finish it" and it's like "uhhh never? but thanks wow" so you just never know what will connect with people. Especially since I find that engagement on comics is really, really low, so usaully I just have...no feedback from anything I've produced.
So I stay motivated by thinking of every single project as a stepping stone towards the storyteller I want to be. So if it's less than perfect right now, it's fine. It's like making a video game, it's always a mess under the hood, and we see all of the problems with it because we made it, but people reading it may not even care about those things, they just want to read some fun content. We're our harshest critics.