Custom moderator automation would be a very valuable tool, bots are terrible at beating bespoke solutions. Is there some open source Amazon lambda clone that community platforms could easily make available to their power users? Funneling automaton onto a platform runtime could be extremely helpful in distinguishing between good and bad automation.
Bots can definitely contribute meaningfully in many ways. Mostly through organization (suggesting labels & other metadata, album creation, etc), spam filtering & rule enforcement (like reddit's automoderator), and even automatic editing (like some of the stuff Google Photos offers, like rotation suggestions and various automatic filters).