Oddly enough, precisely the opposite circumstance describes most farming.
1) People who wanna grow mind altering plants and fungi.
2) People who are worried about destabilized food supply chains and would rather have $10 lettuce than no lettuce.
Both groups have priorities that come before riding the razor's edge of economic efficiency.
Why do you support local farmers? Like on a deep level? Deeper than "well they're my neighbors" Why do you support your neighbor over some guy in Nebraska? Probably because his culture an interests align with yours whereas the same is not necessarily true about the guy thousands of miles away and all the parties between you and him. You'd rather be slightly less dependent on the long supply chain than the short one.
Local foods are, as I understand it, supposed to be some combination of more eco-friendly and supporting local farmers.
Growing a potato in your kitchen cupboard using hydroponics and PV+LED is very local, but you'd have to grow a lot of them before you saved more on transport and processing emissions than created by the equipment; and you certainly aren't helping local farmers by doing it yourself.
I'd also like to know what these magical nontransportable crops you have in mind are.
Verticality (including regular shelves on a single floor) is good for density (may be cheaper to build), but has energy density issues for some crops.
https://www.mapsofworld.com/thematic-maps/arable-land-map.ht...
It's the same nonsensical reasoning behind putting solar panels in places where they don't make sense. I remember france putting money in a solar panel road that was both ridiculously overpriced and ridiculously ineffective for reasons completely predictable. Of course places where solar panels made sense were in essence still barely utilised. Someone just made a lot of money off of the invented scarcity.