Wind and solar power at a household level is very doable, actually, and is improving.
Hydro, however, isn't really realistic on a small scale, but very good at a national level.
Fusion is nearly as bad as fission, and it's definitely not possible (at least not for maybe a century) on such...