Dojo is just machine learning optimised hardware, and it's optimised specifically for the FSD use-case which is lots of image processing.
I can't imagine it having any benefit whatsoever for Tweet moderation above using some GPUs for ML.
Also Musk likes to pitch integration between his companies but the reality is that there's very little.
How good will it be? ¯\_(ツ)_/¯ DALL-E is pretty good, let’s see where this goes.