I think that there will be no repeated excitement. The second time, nobody will not react to the words of Elon Musk as at first time
This holds truth, can't expect the next tweet would be as impactful as the first tweet, and in each every pump caused by that tweet people losing money aswell because get FOMO'd and they could be elon's tweet lurker aswell. I would not consider using bot to monitor elon's tweet and invest based on it as a serious trading, it's mostly just testing the water.
I do follow him but not in the sense that I will instantly buy everytime he tweeted something, it for sure not to cause much impact than it was before but some may still follow his tweets provided they will watch their fully since it's Elon strategy to create a hype and then dump later on. It will benefit many who do day trading but not those who have bot.