I don't know that I see a lot of benefit to having an option of 'Eat Lavish meal every X days' like you would for drugs. The mood boost lasts for a full day so it would be easier to just manually tell the pawn to consume one of you're planning to abuse them a bit or they need a big mood boost. There's already a default Lavish meal restriction that can be set if you need it for more than one time also.
To note : my thread is about foods that are more drug-like, not great as an actual food, like Chocolate and Insect Jelly, while high quality meals assigned as drugs would be IMHO out of scope of vanilla.
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.
Generally Randy on standard Losing is Fun difficulty. Once you've got a full killbox and fully equipped pawns unless you get a weird combination of threats most raids do end up being fairly trivial.