The real magic of hydroponics is the ability to flow a lot of highly oxygenated nute soln through the roots. Various watering systems and media do this to a greater or lesser degree and with various quirks and caveats.
Highly absorbent media (rockwool, etc) tends to act
somewhat like soil. Faster and more productive than soil but not quite the top performer among all media types. Lots of water storage, but because water is retained in the medium, you can't get more in until the plant has removed the last splash you gave it.
Less absorbent media like clay pellets can be watered quite frequently, often 3-5x per lights-on, dependent upon a few factors. The more often you can water, the more O2 to the roots. However, with little water storage, there's little tolerance for watering system failures (pump, timer, etc).
Medialess systems like DWC, NFT & aero are the ultimate in getting lots of oxygenated nute soln through the rootballs. However, they are also the most sensitive to watering system hardware failures. DWC in particular has an Achilles' heel in that airflow to the airstones/bubble curtains in the nute soln in which the roots are submerged must be maintained 24/7. An air pump failure or a power outage can be a disaster as without constant air supply, roots will drown.
At the end of the day, the best hydro system is the one that suits the amount of attention and effort you want to put into it.
I use pots of absorbent media in flood systems because the method is very fault-tolerant. I'm a stoned slacker and may not look in on my op every day. Flood systems are no-brainers- no way they can clog, no periodic preventive maintenance needed. If a water pump quits for some reason (air bubbles caught in the pump chamber are common), I have at least 2 days to catch it, given the 175mm dia pots I use. I used to use pots stuffed only with rockwool floc but have recently switched to
Fytocell. Fytocell is a bit less absorbent than floc and can be watered 2x day, where floc could only be watered 1x/day in most cases. It still gives me a 1 day backup even in the case of large plants in late flowering.
I sacrifice absolute max yield for ease of running the op and low labor input. I could easily add 30-40% to my yields if I were to put more work into it.