I see no foreseeable future in which it makes any sense to erect massive, power-hungry concrete towers, pump huge volumes of water up into them, build fleets of drones to carry small quantities of vegetables back down to us on-demand, and drive it all with an absurd amount of software and hardware, much of it requiring rare earth materials.
Maybe if we had nearly free/infinite energy it would be possible. It still wouldn't be smart.
Vertical farming may make sense in a small number of cases, likely where existing buildings can be renovated and repurposed. Localized, sustainable horizontal agriculture is way more energy-efficient, cost-effective, and ecologically sound in most cases.