Stream flow variability doesn’t affect micro hydro power generation at all unless the stream flow rate becomes less than the hydro design flow rate. Run-of-the-River hydro doesn't divert any stream water or affect natural flow at all. Hydro power is 24/7/365 which gives it a large advantage over everything else. Permitting can be an issue and it’s always best to work with a certified water rights examiner to first sort things out.
Air has a much lower density than water. So you need a lot of wind and wind machine compared to hydro to generate the same amount of power. Small scale wind power generation is often not practical or feasible.
Most of the off-grid folks in our remote and rural area use a combination of micro hydro power and solar photovoltaic to charge their batteries, which are often of the Edison nickel type. Hydro power is plentiful in Winter and solar power is plentiful in Summer. Some also additionally use simple diesel engines like the Lister or Listeroids that run on waste motor oil or vegetable oil which can be readily obtained when gas or diesel isn’t available.
If you like streams and fish, consider making a donation to WaterWatch:
WaterWatch Celebration of Oregon Rivers