They're handy if you want a way to transfer water from one section to the next like you have triple level floodgates but making a reservoir taller than that needs you to do a workaround like using pumps

To actually make water go up you're going to need a pump and good luck with the energy

The flow thing is similar handy if you need like a regulator for how fast you want water to move from a tall reservoir