I'd rather haul buckets of soil upstairs than buckets of liquid upstairs.
I wouldn't mind giving hydro a go, but there's no plumbing near the grow rooms.
I've never looked, but guess "hydro" requires lots of water/liquid.
As for advice . . . it really doesn't take a ton of soil to grow an ounce of top quality weed.
Depending on your intent, find containers that suit YOUR needs.