He is worshiped from afar but reviled by many the closer you get to his inner circle. Go read "Elon Musk: Tesla, SpaceX, and the Quest for a Fantastic Future."
The question I always ask myself with the people who move mountains is what cost did that progress come at? What would someone's spouse, kids, friends, etc. say about the person?
Some of us are great at spending time with our wives and taking the kids to soccer practice. We fill our lives with family and friends, and get immense joy from that. We're so busy, likely, we'll never do anything "noteworthy" or wind up in the Guinness Book of Records. (Note: I'm not in any way implying that's a bad thing, I'm simply stating it as likely true)
Others in this world maybe are not so good socially, or maybe do spend "too much" time at work, and do burn out those around them. They do, however, achieve greatness that genuinely moves the entire human race forward.
It just so happens that second kind of person is around one in a few hundred million, so there really aren't so many around.