Earlier quoted context omitted.
I saw a video like a month ago on YouTube where somebody pumped something like 250 liters of water on his roof (7 meters elevation, if I remember correctly) and let it run through a homebuild generator. The power capacity of that setup was like that of an AA battery, if I remember correctly. You need huge amounts of water and lots of height difference.
Based on some extremely back of napkin math (e.g. doing one of those activities where you cycle to power a light bulb) that seems pretty far off. Was the flow rate extremely low? Have a link?
Wolfram Alpha [0] says this is about 5 Watt-hours, and gives some other handy comparisons:
> ≈ 0.45 × metabolic energy of one gram of fat ( ≈ 38000 J )
> ≈ 0.63 × energy released by burning 1 gram of ethanol ( ≈ 27000 J )
> ≈ metabolic energy of one gram of sugar or protein ( ≈ 17000 J )
> ≈ (0.02 to 0.09) × typical kinetic energy of a car at highway speeds ( 200000 to 900000 J )
> ≈ 0.5 × typical battery energy content of an alkaline long-life C battery ( ≈ 9.6 W h )
> ≈ 0.55 × typical battery energy content of a nonrechargeable Lithium-Thionyl Chloride AA battery ( ≈ 8.6 W h )
> ≈ 0.92 × typical battery energy content of a carbon-zinc D battery ( ≈ 5.2 W h )
Gravitational potential energy is just really, really low energy density. Fortunately it's reasonable to have pumped-storage reservoirs that contain trillions of litres of water.
[0] https://www.wolframalpha.com/input?i=1750+kg+metres+in+watt-...