>> there are some personality types or people
Yes, assholes in particular are bad at being managers.
On a more serious / less sarcastic note, you seem to have a preconceived notion of what autism should look like and/or what range of behaviors it entails. There _are_ types of it that would cause one to be an exceptionally bad manager, but there is also a strong possibility (that I think you need to consider) that your manager's flaws weren't caused by autism at all. People with severe autism typically don't make it into management positions in the first place.
I consider myself to be on the spectrum. I'm never the "heart of the party" (nor do I ever feel any desire to go to parties), I find it somewhat anxiety inducing to approach people I don't know well, stuff like that, pretty mild. If it I didn't feel like it impacts my life in a negative way, I'd call this "strong introversion" or the like.
Yet I'm basically the polar opposite of what you've described in your original post (other than being hard-ass on code quality), and I've received glowing praise from my former reports. I give people guidance and autonomy, and let them be adults. And if they aren't, I give them more guidance and perhaps very slightly less autonomy. If they can't function in this set-up, we part ways. This, by the way, happened only once. The person just didn't want the job I think.