Believing that those who behave in Certain Ways have good intentions. (I've fallen afoul of this, too.) There are certain behaviours that, despite appearing benign or even benevolent (especially when considered together with the actor's explanations), have ime a 100% "actually that was malicious" rate. These are quite sophisticated bad actors, and I'd rather they don't know the tells I've identified, but one of the tells involves the charismatic weaponisation of "cancel culture" by abusers, with part of the tell being to wield "the people's" authority (for some value of "the people") to attempt to modify the composition of a moderation team. (I haven't seen the complete tell in this situation, so there are still benign explanations: this just explains my bias in https://news.ycombinator.com/item?id=45403417.)
An impedance mismatch between the behaviour of the new moderator, and the behaviour expected by the community. For example: erring too heavy-handed, or too hands-off; mistaking banter for abuse, or abuse for banter.
Not speaking truth to power. In most BDFL-type collaborative projects, the founder guy turns out to be really ill-suited for the role, in one important respect. (Examples: Richard Stallman, Linus Torvalds, Andreas Kling.) In many cases, an intervention can resolve this, and save the organisation for a time (e.g. the 2018 Kernel Maintainer's Summit: https://lwn.net/Articles/769117/); in other cases, the organisation heads down the road to irrelevance (e.g. the FSF). (This is of course not the only kind of situation where you'd want to speak truth to power.)
Speaking truth to power undiplomatically. Power is still power: if you suspect the guy in charge is going to take your intervention badly, raise your concerns to the court jester. If you suspect the guy in charge is a bad actor, tread carefully.
Attempting to use an ethical philosophy not conductive to moderation. These include "let's let everyone do everything not illegal!", "if you have anything good to say about bad people, you're a bad person!", "those who disagree with me are bad actors", "can't we all just get along?", "I want to make sure I'm temp-banning the right person before taking action", "it doesn't matter if I'm temp-banning the right person", "people should follow the rules", "people can ignore the rules if they have a good reason", "we don't need lots of rules", "we should design rules that work for every situation", and "we should rely on moderator judgement".