I don't think he intended Twitter to be a good financial investment. It seems like he bought it for its power in the public discourse. Whether or not that investment paid off is an exercise for the reader.
The failures of other electric car companies; Fisker Arrival, Dyson EV, Nikola, Faraday Future, would seem to indicate that being merely competent is a higher compliment than it feels like it would be.
His biographies go into far more detail than fit here, but even if you only believe half of those stories, he is still way more involved that most investors. At one point he slept in his office at the Fremont plant to get the Model 3 launched. There's more to him than being able to sign a check.