Cheap in terms of capital, but home hydro tends to take quite a bit of labor and maintenance over time. If you look at that stuff as a fun hobby or YouTube content it’s no big deal, but economically your labor isn’t free.
I’ve got an usually good location for small scale hydro, there was even a mill on the property, but it just doesn’t seem worth it to me.