This, yes, if you want to feed the whole town from inside production, the try isn’t reasonable. I have heared London has a company doing soilless agriculture inspired by canabis factories… I am not sure how it went.
Yet if you take it at an individual level, being part of a 100m2 community (each have their own lot) can be interesting, if well organized.