LED powered farmhouses would be nice. But going back to the person that you commented on, now we're making energy to give to plants, instead of using the sun directly to make plants. This has the potential (especially in today's economy) to increase the carbon footprint of urban growing.
Certainly local. Fresh most likely. Efficient? Not so simple, probably not as efficient. And unless you're using GMOs that are resistant to invasive insect species, you'll still need pesticides (or lots of human hours....which severely decreases efficiency and increases cost).