I stumbled into some of the problems that you describe so eloquently when I challenged myself to make a Stardew Valley farm that feeds all the townsfolk.
https://cliffnordman.com/blog/2022/07/25/feed-pelican-town-a-stardew-valley-chal...
