Yes, to be fair, there probably are some exploitable niches unrelated to crappy land use (which I should point out is much more common in the parts of the US that co-evolved with the automobile).

For example, fresh herbs cost a fortune in grocery stores here, and are festooned with single-use plastic packaging, and come in far larger quantities than one can reasonably use before they go bad. So it makes tons of sense to have a little herb garden in your house or yard, especially if you can grow things that are adapted to your local climate (e.g. my rosemary bush is taller than I am).

But I think the optimal scale inside of expensive cities is probably closer to "houseplants that you can eat" rather than an urban farm.