I have dual pivot on the road bike and hydraulic discs on the mtb. Hydraulic discs for road bikes are unnecessary in my opinion. On a mountain bike you are dealing with much more hostile terrain, mud, water, ground gritstone (iif off road in Peak), technical terrain under wheels, rocks, roots, drops etc. separating braking from the requirements of strong light rims allows you to build wheels able to take this abuse time after time. Replacing disc rotors is easy and doesn't cost as much as a new wheel build.
For road bike descending 25% gradients can overheat the brakes if you drag on them, and this can explode the inner tubes. Those kind of gradients aren't that common, and by not dragging on the brakes, you can overcome the heat build up.
If you are thinking of a cyclo cross bike then by all means look at hydraulic. But not cable as offroad cable discs have gone the way of the Dinosaurs for anything properly off road I.e. not counting easy non technical stuff like the SDW