I was once tasked with designing automated greenhouses that were supposed to be very profitable, which means that they would use little energy and little labor.

The project did not go forward but I still do think that small units of automated, local, efficient food production is the future. I don't think single-house size but maybe a dozen households could share one decently sized greenhouse and grow most of their plant-based needs.