I genuinely wonder what the costs comparison looks like for these options.

I could see the use case for hydrogen as a battery, in rural areas where transporting power over wire would be cost prohibitive. The added benifits being that if you used most of the fuel in between electrified lines you lose the weight of the fuel unlike batteries.