Seek therapy and learn various ways to stop negative thoughts.
As for the professional world of writing, it's the marketplace's job to judge, not yours. Write your books, submit them, and if they are good enough, they'll sell. If they don't sell, you try it again. If that next one doesn't, you do it again. That's how it's done, and most writers are on their fourth or fifth book when one finally does sell (and this seems to be true of trade- and indie-published authors both). If you have no finished books, or if you quit at book 1 or 2 or 3, you won't be unusual in the least. But you also won't be read by people all over the world.
If you're thinking there is some way to be a writer and never get rejected and never have horrible reviews, that's unrealistic. So if you makes you feel any better, rest assured in the knowledge that your writing will most definitely be rejected and/or insulted at some point by someone if you put it out there in the world. That's the nature of the business. Writers learn to live with that fact, or again, they quit writing.
What you see in your local bookshops are the people who survived those realities, not necessarily the best writers who ever tried, but the tough ones. So... get tougher.