To pile on to what another commenter said above, therapy is for you.
I know you dismissed it out of hand. You clearly have no faith that someone (specifically, a well-trained therapist) might have something valuable to contribute.
However, while your powers of observation might border on superhuman, they are still very much just yours. A therapist can help you build an emotional toolset you will not otherwise provide yourself, and which will make you a more complete person, not least of all in the area of building and maintaining meaningful interpersonal relationships.
Think of it like this: you can read music theory and memorize the entire western classical canon by heart and still be a terrible piano player, never improving if you don’t show up to practice at the keys with a talented teacher.
One simply cannot reason ones way around the emotional core that drives us as humans.
CBT will help you change your behavior and how things feel, but, imho, psychodynamic psychotherapy can go much deeper and truly improve your emotional IQ.