I gave a presentation to the Apex Writers Group tonight talking about how to overcome the fear of failure. I had a long list of stories and examples, and had a lot of fun with the topic. If you're not failing from time to time, you're not setting high enough goals.
As one example,I set a goal in 2017 to receive 30 short story rejections, so I turned the negative of rejections into a scoring mechanism. I ended that year with 41 submissions, 34 rejections, and 7 sales. Without the weird goal, I wouldn't have submitted nearly as much or paid as much attention to submitting my short stories.
Speaking to that writing group can give you a strong case of Imposter Syndrome. If you look at their website, they list Brandon Sanderson and other NY Times bestseller authors as past presenters.
If you're interested in writing, check them out to see if the group is a good fit for you. It was Dave Farland's brainchild, but it's carrying on with others at the helm now that Dave's gone.