Agreed wrt Twitter.
As for all his companies being a scam... I think the evidence suggests otherwise.
Tesla sells the best EVs on the market. Objectively that's a fact, they've been ahead of the game for over a decade - but yes, the constant promises of FSD "soon" were erroneous.
SpaceX has the NASA contract because they make better rockets than their competition. There's multiple videos and livestreams of SpaceX reusable rockets not only successfully launching but also the thrusters landing on small targets in the middle of the sea. Reusable rockets are a big deal.
SpaceX is also behind Starlink which is expensive, yes, because it's new technology, but it works. Speedtest data shows that in many countries it's faster than normal broadband on average.
Elon was a co-founder of PayPal and Tesla, and the sole founder and chief engineer of SpaceX.
Don't get me wrong, many of your criticisms are perfectly valid. He is very good at using his memelord status as a marketing tool. He is not totally honest and has his own agendas (he is after all a CEO). I'd also add to this and say he's often immature (Thai diver drama) and doesn't always think things through (Twitter purchase).
And of course he puts on a persona for PR reasons to keep his fanboys happy. Recently he tweeted against the WEF calling it an unelected world government (which is true) but a few weeks later he was at the World Government Summit which has such a strong overlap with the WEF that Klaus Schwab himself was a keynote speaker.
I have no strong feelings about Elon myself and my distrust of him has only been growing recently. I don't trust a word he says about politics and world events. Like you say it's all just a narrative.
But saying he's simply a con artist whose companies have no merit at all just isn't supported by the evidence.