No good person becomes a billionaire. That's reality. Only semi-awful people do what it takes to become giants in their field, and are either a bit defective, or willing to sacrifice so much of the other parts of their lives (because no one can have it all). That applies to any 'great man' in history, from military leaders to today's CEOs. At the very least, they are so driven they will sacrifice traditional happiness in the pursuit of fame and treasure.
That said, i admire intelligence and that sort of drive when it delivers something that is beneficial. I am not a fanboy, but heck, the man was a young multi-millionaire worth a couple hundred million after selling off paypal. He could have pissed away the rest of his life living a life of extreme leisure having poured his early youth into something that succeeded- and that's what I would have likely done were I in his shoes. I would live the kind of car life that would make our beloved Toaster, Dave and other well-heeled enthusiasts blush. My biggest challenge would have been which (insert car) to order until the next (insert car) comes up on allocation, and in which house to park it between trips around the world with a few playmates in tow.
Instead he took on what he saw as a problem, and has done that with both cars and rockets (and internet). Society will benefit from this, you have to admire the fact he took electric cars from being mocked to the entire industry now shifting in response - that is unbelievable. Then he is doing the stuff with Space X, and the sat internet, on and on. Every one of them so far has delivered actual massive improvements over what was the industry standard (except for things like Boring company but who knows the long-term plan there).
I don't like some of what Tesla is planning (it wants cars to be self-driving pods - yuck) and clearly they aren't into enthusiasts of driving which I hope BMW and others cater to as BEVs mature, but it is marching to its own tune, following a plan that has been clearly laid out, can't fault them for that. When Tesla went down the Model 3 path, i really didn't know if there would be much demand beyond the first couple of years for their mainstream BEVs, and it seemed silly for them to move away from their rich tech world core where they could have just been a small premium maker of cars catering to silicon valley. Why purposely move down-market when every carmaker tries to move up-market? Because they wanted to do more than just be a Porsche type car maker.
I also like and at least respect his oddness, that at least he does not spew absolute non-speak like, for example, Apple's CEO, or even Barra to look at the auto industry. The amount of review and polish things get from multiple departments in big companies before ever seeing the public eye ensures nothing real really gets said. By contrast, you have this odd, driven semi-crazed dude tapping out tweets at random hours, while running multiple companies and living an extremely odd personal life. I'll take that over Tim Cook with his stupid V sign and empty smile, or any CEO that is kept on a tight leash lest they say the wrong thing.
At least with Musk, you know how strange he is, and he does not seem to hide too much behind a carefully cultivated image of niceness, while being a depraved freak in private, like so many people.