Most of those comparisons are done in bad faith. As you said, they compare the whole chain for renewables/electric cars/windmills (parts of that chain could be decarbonised down the line anyway) to just the burning of the fuel, forgetting about extraction, exploration, transport and refining. Before you even get to the stage where you’re burning fuel in your engine, there’s been multiples of the CO2 and other greenhouse gases emitted already.