I wish I could offer some answers, but at least I can relate to how you feel. I would read a How to Live for Dumbies book if there was one. ADHD seems to go hand-in-hand with my AVPD and ADHD medication has helped me socially to the extent that I'm capable of typing this very post as insignificant as it may be.

People are complicated and frustrating. I prefer the company of animals and maybe a pet could help you attract more desirable people if not just keep your company.