I mean, it's quite literally thankless work and unpaid labor. That wears on you after a while, after the glow of power and responsibility fades.

If you want pro-social, community-oriented mods, you pay them a living wage (like MetaFilter does) and give them more than just circumscribed authority and literally zero tools that the community didn't make themselves. Otherwise, you get what you pay for