I sort out my relationships this way, basically:
Extended Family: Till Death do us part. Family will always be there for you, even after you bring disasters to fall on you.
Friends come & go. They are not family, except for a very very very few. Do not confuse Friends with Family.
For True Friends are rare, you can count on your fingers. These friendships are gifts, and cannot be forced. And these true friendships survive long absences.
Personally, I aim not to be needy with friends. See you when I see you. I too do not want to be burdened with required social attendance.
Don't get too attached to friends; learn to let go. Learn to love your own company .
What else? I do not give advice nor comment unless asked. Believe me, for a curious & opinionated person like me -- that is a real hardship. Hahahahaha
Giving Unsolicited Advice is like being the bearer of bad news: they just itch to shoot the messenger.
I make new friends all the time: based on current interests, concerns, business matters, whatever.
The operative word: current. That way, I do not look forward to more than what a friend can give of herself/himself/whatever-self at any time. So, no-stress friendships. And I or my friends do not "overstay our welcome" in each other's lives. No letdowns, no disappointments, no ill feelings that way. Moving on, moving on, moving on.
But rest assured, I do get long-lasting deep and true friendships too along the way. Yung type na kahit years kami hindi nag-usap or kita, when we re-connect: it's just like yesterday. Plus, when I urgently need help/whatever: no questions asked. I am very blessed to have such true friends.
I am an imperfect person, I know. But based on the above guidelines,I am able to not beat myself, from expecting too much, when a friend disappoints/hurts me.
I do a check, of course: if I may have unwittingly offended her, or done something with malice. If apologies are in order, I deliver.
But see, there is a price to every friendship. Am I willing to put up with her/his/whatever "warts": moods, recreational drug use, obsessive-compulsiveness, innate kalandian, tendency to backstab, drive to control, social-climbing, neediness... whatever "wart/s". Assess, move on without "closing doors", no regrets.
What am I trying yo tell you about your situation?
That: I do not think it's a psychological problem. IMO, it's a perspective problem: yours. Just adjust your expectations of friendships, & give a big allowance for human faults. It's not you, always; it's them too, at times.