Welcome .
Hydro is my prefrench, especially on large set ups. It's clean, no soil or media to dispose of, it's fast, simple and get the most bud. However, I always get my best results in coco. I never ever have note issues, ph issues or other probs associated with hydro. I'd say coco is most user friendly and I get better quality from that. I never ever grow in soil any more. Had a spell using super soil and it was fantastic but numbers dripped to 12oz per light average which is half my usual amount and it was a lot of hassle mixing soil.
Remember coco is basically hydro too. I use run to waste. I find water usage between recirculating hydro and run to waste to be very similar to be honest, slightly more with run to waste but not huge difference.