Eh, I have had mixed results.

There are also moderators that ban out of some weird form of spite/echo chamber enforcement.

Ive seen some examples of feminist / human rights forums/subreddits that had it explicitly in their rules that hate speech and attacking people based on gender was against the rules. Someone was going on a long hate filled speech about how all men are trash and terrible, and I just reported it to the moderators that it broke the rule and I proceeded to get banned for making the report (not even engaging with the chat, just reporting)

I also got banned from /r/askscience during the late stages of COVID and was accused of being an antivaxer by the moderator... Thing is I am extremely pro-vaccines, lol

The reason I got banned? Someone posted some faulty stats interpretations of information and I posted the correction, giving an example case to demonstrate how there was a hole on their claim. Largely speaking they were, in a damaging way, accrediting assumed success to vaccines that wasnt quite proven yet, and I was just like "Well we'd need to the info for X/Y/Z to make that assumption, its very possible but we are missing key info"

Moderator sent me this lol:

We don't allow conspiracy anti-vaxx nonsense here. Your understanding of stats in general is incredibly flawed.

So yeah, sometimes you just have moderators that are complete assholes and genuinely seem interested in enforcing some kind of weird echo chamber deal, where rationality is not supported.

That one in particular sticks out to me because you'd think that a place like /r/askscience would be understanding of calling stuff out like confirmation biases... >_>;