The term "ideal moderator" is used in the help center of every site which says:
The ideal moderator does as little as possible, but those little actions may be powerful, visible, and highly concentrated.
The ideal moderator doesn't do "as little as possible", they help to clean up their site to the best of their ability.
Every community has charismatic leaders, people whom at least part of the community regards as people who act in the interests of the community, and trust to resolve issues in a satisfactory manner. You don't need to be a moderator to be a charismatic leader, but a good moderator should be one of the charismatic leaders.
The term moderator in all quotes above appears to be referring to community (elected and pro tempore) moderators rather than users exercising earned privileges to moderate.
Is the most important trait for a community moderator:
- doing as little as possible;
- helping to clean up their site to the best of their ability;
- being one of a community's charismatic leaders; or
- something else?