The hydrogen ladder offers a good overview of where hydrogen makes sense and where it doesn’t: https://www.linkedin.com/pulse/clean-hydrogen-ladder-v40-mic...
For me methane pyrolysis from biogas seems like the most realistic way of carbon capture (while also producing hydrogen).