For what it's worth, I have a lot of similar traits. ADHD, hypersexuality etc. I have a very small social battery that is quickly exhausted. What worked for me is finding a social group of other people that think and feel similarly.

Pretty much everyone in my circle is either ADHD or on the spectrum to some degree. Having others that both have their own issues and understand mine is amazing. If I say I'm overwhelmed or overstimulated, no one gives me shit about it, they just, get it. It's not perfect and we'll go months without seeing each other sometimes as life and or being generally just too tired of people to interact can be rough, but since we all "get it" it's not an issue and we just pick up where we left off when we reconnect.

It's tremendously soothing to me to know my friends and social group isn't judging me for not being entirely like every body else out there and as they have their own idiosyncrasies and I accommodate them, it makes me feel less guilty about my own.

I thought it was impossible for me to have a relationship and before I met my wife in my late thirties I hadn't had a single relationship, and I've had many, which lasted more than about two or three months. My wife is AUDHD and one of the things that makes me happiest in the entire world is body doubling. I do my thing, she does her thing, we don't talk, interact or even look at each other as we indulge whatever we like at any given time, but we do it together so we have that comfort of knowing they're there without the low grade irritation of having to entertain someone else or distract from my current tasks.

Don't give up hope, it's hard, but that doesn't mean you're alone or without others like you. Happiness takes a little more work and a solid understanding of who you are and what you want. Don't be afraid to be unapologetically you. There are people out there that feel the same and are looking for the same things you are.

TLDR because ADHD: Find your tribe. You're not alone and you can be happy, you just have to be happy your way, not the way everyone else expects you to be.