Automation is a big part, but it will always require manual intervention by design to keep things running smooth. The best parts of the game the once that require a players touch in my opinion.

I'm also a player that tends to get bored with endgame colonies once raids stop being a threat though so the worst aspects of a very large colony are probably lost on me. If the feature helps someone then I hope it gets made, but I would worry about performance with this type of a change because you're forcing a mood check(and possible recreation for the OP request) with every hunger check per pawn.