I can still remember ads for the "Biotron" flourescent grow system in various magazines back in the '70s --- the ad featured roses, but of course the actual usage was typically for growing marijuana. (Later that name was co-opted by the Micronauts toy line/comic books for a character).

The O Garden seemed an interesting modern spin (couldn't resist the pun):

https://www.coolthings.com/ogarden-rotating-indoor-planter-w...

(but I think they went under? The footprint was kind of extravagant)

I still think someone needs to work up a unit designed to fit next to a refrigerator --- bonus points for circulating filtered air so that the heat from the fridge is harvested for the plants.

The other option I've been curious about is a window unit mounted like an in-window air conditioner (maybe you could combine the two? harvest the condensate and heat for the benefit of the plants?)