I moderate some smallish subs (5-10k users) and don’t really make many mod actions. Maybe 5 in the past 15 years. The subs are still pretty good as measured by increasing subscriber counts and my own enjoyment.
I think the huge subs probably get a bunch of spam, but then I ignore them even with moderation.