He's got a winning track record. You may not agree with his politics or his morals but that's separate from his effectiveness.
Specifically he's effective at stepping outside the domain he currently operates into create inside another.
If you can't then you're just speaking from emotion because they obviously exist.
My personal experience with Elon's promises is through the Model 3 which I do own, and essentially none of his promises for it have materialized. It hasn't morphed into a revenue-generating taxi which drives around strangers at night; it can't be summoned from across town (or even across a parking lot); it can't even safely drive itself without oversight, which was a goal only "months away" in 2019.
SpaceX is what gives him leverage but the success of the reusable rockets are the engineers behind it - he's just the ketamine-driven hype-man that drives the stock via publicity now.
What exactly would that be a winning track record in - as near as I can tell, his actual track record is in buying companies with an already-successful product team, and managing not to run them into the ground for a while?
This isn't really a benchmark for effectiveness at anything beyond making money.
I don't think anyone would dispute that he has an eye for investments (helped along by a healthy dose of the ol' silver spoon), not to mention a certain flair for convincing Uncle Sam to pick up the tab (i.e. a significant part of Tesla's growth relied on federal EV subsidies, and NASA heavily buying SpaceX launch capacity).