The more he puts himself out there, the more you see behind the curtain.. the harder it is to like him. On one hand I can see that he bought Twitter because he thought he would be loved for it and be un-cancelable. And he was probably sick of the endless media storm shitting on everything he did. It may be the one thing that backfired on him though after many successes. I too really like the spaceX stuff and I'm not sure that it would exist without him. And starlink, is world wide life changing tech.
His ideas for Twitter just showed that he's got flaws for sure .. he talked a big game about how it would all work, how it wouldn't be beholden to advertising revenue, and seemed to forget that it is just a large media corporation that will fail unless it keeps running exactly the same way it is..
I got off Twitter soon after the doge icon, so I wouldnt be reminded that he is so troll-y. If only he could have been happy posting on 4chan or something, but no, he really did want to be a huge unstoppable celebrity on his own platform, and to be liked.. and I think it actually may be ruining him mentally.