Every time I read one of these threads I wonder if I'm somehow seeing different screenshots that what the author is talking about, because they're always full of some of the most uncharitable interpretations possible. The tweet linked reads like a biased summary of a biased summary.
I don't know people expect moderation to work, but it's inherently messy and imperfect because humans are messy and imperfect, and past a certain point you always end up having to trust the instincts and judgement of moderators.
As someone who has moderated large group before, my main reaction is "this stuff is surprising to people?"