Why not write fiction just for yourself? Just because creating stories makes you happy?

Perhaps divorcing it from the need to do it "for" external success, would allow you to enjoy it again?

Writing is like any skill - you only get better at it with practice. You can't just say "I'm not good enough" as if that's a permanent quality of yours that you can't change. No one is good at anything, to start with. I was shit at art for years, and only became less shit over time.

People like Vincent Van Gogh were considered "bad" at art because of their unconventional style, and yet the authenticity of the art resonates with people so much now.

As for friends, I find it hard to believe that out of billions of people in the world, no one would ever want a meaningful connection with you.