I’d argue that one of the reasons Tesla and SpaceX are successful is not just because Elno is a “visionary” (or functional equivalent). It’s because he was/is supported by a cadre of “true believers” (eg that we must disrupt the auto industry in order to do something radical about climate change). Those true believers (like all true believers), are willing to put up with lots of strange behaviour in the name of that belief.
Twitter on the other hand was bought with a management layer that could fairly be characterised as the opposite of true believers in whatever Elon is selling. Hence the implosion.