Your words are very poignant. I can say that for almost my entire life until recently, I felt the same way. I don't know if this will work for you or anyone else, but I can tell you what worked for me and got me to a place where I have constant proof that I am exactly what at least a few people want* and need. What changed over time is when I got to a point in my learning/recovery that allowed me to completely eliminate the last set of "mediocre" relationships (friends, acquaintances, coworkers, whomever), and live in outrageous celebration and vindication of myself. What I mean is that to the fullest imaginable extent, I don't waste any time on anyone who has not proven beyond a shadow of doubt that they are worthy of my time, my stories, my presence, my mind, my beauty, my anything, and I don't even make the slightest excuse for anyone who does not 100000% support me in every way. No excuses.
I choose to be the most honest and most complete version of myself possible any given moment of the day, to the best of my ability, and I make zero adjustments for anyone. I had already eliminated extremely toxic people from my lives years ago, but I still needed to weed out some others who were harder to detect (yet not that hard... I had been in denial and making excuses because some "infractions" seem "small"... but the truth is anything, no matter how tiny, bothering your gut, is a huge huge sign that something is very wrong and may need to be eliminated). If people don't want it, can't handle it, criticize it, and/or live in whatever lesser form of love/honesty/and truth than I do... then bye bye! What I was left with was a tiny team of real people. But they are the truth, and they want* and need* and truly love and accept me. I also found the same sense of want in a support group (this is because the support group was so extremely well-run by a fantastic professional who knows how to hold everyone to honesty and a non-judgemental state of mind, meanwhile in normal everyday conditions society almost forces us to walk around hiding and being phony in order to "protect" ourselves, which really ends up hurting us all in the long run).
You are priceless and incredible beyond words. So think about how you would respond, word for word, if you were the person on the other end of the things you say/do to people. Anyone who does not rise to level of response, the quality of response YOU yourself would have given, get rid of them altogheter or at least vow to never give them the gift of "you" anymore, because they clearly do not know how to truly appreciate and therefore are not worth your kindness. This will make space for only the cream of the crop, and these folks will want and need you. They may not know it now, or maybe they do. Maybe they are people you know, or maybe zero of the people you know will prove to be fit for you, and maybe the people you will meet in the near future after you drop all the lackluster ones will be the one who finally want you, for everything you really are.