One kilogram of hydrogen is the energy equivalent of one gallon of gasoline, which produces 9.1 kg of CO2 when combusted.

Carbon footprints are often reported in terms of energy. For example, power plants usually report carbon footprints in terms of kilowatt-hours (kWh). One million SCF of hydrogen contains 79,100 kilowatt hours of energy.

This converts to 0.28 kg of carbon dioxide emissions associated with one kilowatt-hour of hydrogen production.

This article lays it out, is based on up to date metrics for production, and was written by a qualified chemical engineer, in what I would consider, a very anodyne tone.

The key take-away is here:

On an apples-to-apples basis, it depends on several factors but it is likely that the conversion of hydrogen into power will have a carbon footprint greater than that of natural gas-fired power, but less than that of coal-fired power. However, it is possible in theory to capture the carbon emissions generated in the SMR process.

Right now, today, you would be better off burning the natural gas in a power plant than turning it into hydrogen. Its better than coal. The CO2 could be captured, but that's only a hypothetical. Currently, that isn't part of the process, and doing so will incur an energy cost, at which point the ROI will likely be lower than coal.

In conclusion, you should think of hydrogen as a green-washed fossil fuel, because that's what it is.