That's spot on from the advice.
I'll add that OP — Your biggest issue seems to be extremely high intelligence, paired with a lack of empathy and social functioning, which created a self-expectation of massive grandiosity. But you keep failing to deliver on it because you can't get your highly powered brain on the streets, leading in self-pity and depression. Not good, but salvageable.
How do I know? My life story reads basically like yours into my late twenties — multiple college dropout, extremely high ambitions, always failed.
The only difference is that I started that low level support job in a company small enough that somebody saw my talent and got me on the path to second level tech support and then engineering as I continued automating my job away.
Had to chuckle as I pissed off quite a lot of people higher up in that job early on myself, but fortunately had a few people reflecting me instead of firing me, which made me understand how I made other people look and feel by my actions.
The good news: Empathy is a learneable skill. Aim far lower in a smaller, young and growing (!) company with good potential — but especially with a great boss. Then work hard, SHUT UP your smartass mouth for a year and work your way up while learning what's holding you back with the help of a good coach/therapist. When you apply with the company, read everything you can about what they do and make it about them.
Stop trying to impress. For that year, just focus on staying super humble and in the background, learning how value is created for that company and then go on creating that value even if nobody asked you to. Just for a year. Up your ante slowly and only when you feel you have established personal trust and leverage.
Empathy a skill where intelligence won't support you but be in your way because of your natural tendency of you showing it off. That makes people feel dumb, and nobody likes to feel like that. Also, some actions like you skipping line management will make them feel they can't rely on you on top. You'll keep failing if people keep hating working with you.
Your goal is to find a great manager first and make them look great. And then talk about that. Be the solution guy, not the problem guy. Be the one who goes the extra mile to bring a small win home, not the one who makes the snarkiest comment.
You'll never be a "normal" person, but that's ok. Having a sharp profile comes with its own set of (dis)advantages. You can be high functioning if you surround yourself with capable people who know how to work with your weaknesses in order to leverage your strenghts.
Your job is finding them, as you'll fail alone.