I think that is precisely OP's point: on the long term, solar & friends are the only things that matter. If we get unlimited cheap power, we can only ever use it to generate an 'utterly miniscule' fraction of energy compared to what's available from solar because if you want to add a meaningful contribution to the energy content of the planet, you'll simply cook yourself, not from chemical global warming, but from thermodynamic waste heat.