As for the fake user saga, my take is that it is a transparently weak reason to try to walk back from the deal. I think the real story was that after he lost some financial leverage with the crypto downturn he is no longer able to finance the deal without making significant tradeoffs and decided to walk it back. Everyone who knows the internet well (and Elon lives online 24/7) knows that all social media networks have lots of bots so it's impossible for me to think that this is some surprise to him.
He made a bet on the company that he clearly always and still does want. Then the price tanked so he made a gamble and used whatever he could to support his side.
From a purely business perspective it's not that big of a deal to risk some emails/messages leaking in discovery in exchange for a few billion dollars. And ultimately he gets what he wants regardless since it's as much a hobby as a business (like owning a sports team that loses money).