I think Elon can be a good CEO but he's split between 2 good companies, Tesla and SpaceX, and one awful one (x/twitter). Note that I don’t think he’s a nice guy, but he can be an effective CEO given the right situation.
That said, social media has ruined him.