I admit I did get a little caught up in Musk's web of hype in the early days but fortunately my natural scepticism was strong enough to resist him. Eventually, I found a few detailed analyses of some of his technological fantasies which convinced me that some of what he proposes will not be happening any time soon, if ever.
I am by no means an Elon Musk hater but he does speak a lot of nonsense, from time to time, and he seems to be able to persuade many to abandon their scientific scepticism.
I was persuaded by what Common Sense Sceptic says about some of Elon Musk's plans: <https://www.youtube.com/@commonsenseskeptic>, even though he is clearly biased against Elon Musk.
I am convinced that
1. A city-to-city Starship shuttle passenger service will never happen.
2. A self-sustaining colony on Mars will not happen in the foreseeable future.
I have strong doubts about other SpaceX and Tesla claims by Elon Musk, but these two events I would actually bet on.