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.
Yeah, pumped hydro is one of those power sources that doesn't scale down at all. However, home scale conventional hydro is a thing. If you live on a hill with a creek that runs down it you can install a generator that produces a usable amount of consistent power for the cost of a few hundred meters of PVC pipe, a barrel, some connectors, and a small electric turbine. Search for micro-hydro if you want to know more. L…
I've probably seen everything YT has to offer on that. :-D
While I really enjoy those videos and the "let's just do it" vibe with old washing machines as generators, I'm also somewhat happy that Germany has rather strict regulations on how to use water from streams and rivers. Some installations are quite disturbing for local ecosystems. But being off-grid in remote areas these solutions seem like a probable compromise.