I would counter and say that Musk's flaws are what allow his greatness. You don't get someone that effective without serious tradeoffs.
Not many people could have created SpaceX. Even fewer could have made Tesla work. I don't know that anyone else could have done both.
Imagine if every time someone brought up something about Linux the thread was full of people doing psychoanalysis of Linus Torvalds instead of actually talking about the features of the new release. Imagine how useless those threads would be. Your post is an example of this with regards to Tesla.
Call it what you like, this is reality that very few are happy about. Imagine if this guy would be more mentally and emotionally stable, how further he could actually get. And the respect he could actually achieve. Its a sad view, really.
The thing is, people's failures define them and their legacy 100x more than their successes. Nobody cares how loyal friend say Epstein was (ie to Trump), do we.