Except for potential niche sources like your plastic harvesting company you can think of hydrogen like a battery since we get most of it from water. The main way we get energy back out of hydrogen is the thermal reaction created when it bonds with oxygen to form water. This a net loss energy cycle due to inefficiency, just like charging and then uncharging batteries is a net loss due to inefficiency in charging.

More likely than supplying hydrogen to homes, which doesn't sound easy, would be to have hydrogen production units in-home powered by the grid. So filling your home hydrogen storage is like precharging all the "batteries" for all your things that run off hydrogen. You're indirectly refueling those things with electricity you paid for. Assuming the hydrogen was produced with clean energy it's carbon neutral and very energy dense so it's a possibility. I'd say it's future hugely depends on how good battery tech gets, and how efficient hydrogen production/usage can get.

I think it goes like this. Gas: massively inefficient but excessively energy dense and can be produced from non-renewable sources for less energy than it puts out. Hydrogen: great energy density, medium efficiency, renewable, no natural source, so it takes energy to produce, more volatile and difficult to store than gas. Batteries: terrible energy density, expensive to make, and use a lot of raw materials. Really good efficiency and fantastic power demand application(ability to handle extreme throughput spikes without huge equipment, like gas and hydrogen would need larger engines to handle massive throughput)