Does Elon over-hype nearly everything he gets involved with? Clearly yes.
Does he also deliver on some mind-boggling timelines? Well Tesla went from delivering its first cars in 2008 to having the best selling car in the world in 2023, and SpaceX went from not having successfully launched a rocket to delivering about 80% of the world's space payload in roughly the same timeframe. So I'd say that's clearly a 'yes', too.
SpaceX also dropped the cost of kg to space by multiple orders of magnitude, which is a part of the reason they essentially are the space industry now a days. And should Starship deliver we are likely going to be seeing even more orders of magnitude drop in price there.
Elon made some political positions (which he has always hinted at in any case) publicly clear, and the divisive nature of politics in the US which has made a rather vocal minority of people just freak out with regards to him. But the reality is that if he died tomorrow, he would already go down as the Thomas Edison of modern times. And he as of yet still has some years to deliver on Mars which could cement a far greater legacy.