@
Wintropy
I'm not familiar with your exact situation and troubles, but... can I make a guess here? I suspect some of that might stem from cases where people would bail on you for any mistakes, causing a very 'defensive mind' where you might worry more about mistake avoidance than success. Acting to 'not lose' rather than to win, in essence?
Is that even remotely right? If so, consider the environments where you get feedback for the things you do. The ideal one isn't a 'yes man' echo chamber where everyone always tells you you're great (leading to stagnation), but also isn't operating on a 'one strike, you are out' policy either. Willing to call you on errors, but doing so as a constructive thing to give you chance to improve upon them and grow.
If this describes what you're dealing with, take heart; there are environments that offer this. Good work-places/good companies offer it, some forums do as well. Eventually that nagging voice about "this thing I made/did sucks and I suck" gives way to "so long as my mistakes aren't egregiously stupid, they'll give me a fair chance." It becomes okay to make mistakes in moderation because you show learning and improvement.
This is admittedly a very broad guess based on only knowing you for a few paragraphs, but I hope it speaks to something you can identify with and that it helps.