It's also quite hard to find suitably hot rocks suitably close to the surface.
Focusing on fusion .. I think that's a legacy of 60s SF, when the fission revolution was still promising "energy too cheap to meter".
In a world where anyone could just YOLO any reactor into production with minimal red tape, consequences be damned, fission energy would actually be extremely cheap. Hence the optimism around fusion. The promise of fusion is an actualization of last century's idealistic conception of fission. It can be a silver bullet for all intents and purposes, at least once it's established with a mature supply chain.
At worst, nuclear waste contaminates a discrete section of the Earth. Climate change affects literally everywhere. The correct answer would have been to aggressively roll out fission power 40-50 years ago and then pursue renewables. You can argue that other solutions would make fission power obsolete, but we would have been in a much better spot if it'd at least been a stepping stone off fossil fuels. Instead, we have 40-50 years of shrieking and FUD from environmentalists over an issue that can be kept under control with proper regulation. The US Navy has operated reactors for over 60 years without incident, proving it can be done with proper oversight.
TL;DR nuclear has issues, but I'd take it over coal every day and twice on Sundays, at least until something better can scale.
I wasn't really commenting on the merits of 20th century environmentalist movements, more raising the general point that fission power has inherent costs which weren't reflected by narrow 1950s analyses of how much energy was extractable from U-235. Operation of a fission plant requires much more capex and opex than it would if we didn't care about cleanliness (waste management), security (fissile material theft prevention), or safety (meltdown prevention).
Fusion power is more complex to invent and practically depends on modern technologies that didn't exist 50 years ago, but once the first demonstration plants are operational, marginal costs to deploy and operate more should be much lower and ultimately become very low at scale.
Denser urban living is pretty energy efficient, and forcing lengthy commutes on people because of NIMBYism is a huge waste.
Similarly, better to have people be able to have reasonably energy-efficient houses than demanding they all live in apartments.
The only ones demanding anything are those who show up to try and stop apartments.
(Source needed. This probably depends on a lot of variables in play.)
Plenty of people in dense urban areas are happy with living in an apartment and, where I live, buying a condo in the city is at least as frequent as buying a house 20 km away from it for the same price.
Living in suburbia has its downsides - long commute, very limited entertainment and cultural possibilities, very limited choice in schools. Not everyone loves cutting the lawn etc. either, I surely don't. If any of your family members has any disease that could flare up, ambulance response time tends to grow worse with the growing distance.
Of course, a lot depends on factors such as "is the transport authority willing to make public transport actually safe and nice". That requires keeping raving drugged lunatics out of it, plus paying enough money for it. AFAIK in the US, Republicans have an ideological problem with the "paying money for it" part and the Democrats have an ideological problem with the "suppressing antisocial behavior in it" part.
Chernobyl took out Welsh farming for years, and in a few places decades, because it spread a thin layer of bioaccumulative poison over the whole of Europe.
Know what else spreads a thin layer of poison over the whole of the world? Coal power.
Democracy just as lazy and apathetic is whatever the USSR counts as; the point of capitalism (which is different to democracy) redirect the laziness into something more productive — this works to an extent, but depends on competition which is greatly reduced in the case of nuclear reactors.
That it's a different axis than democracy-communism is also why the not-at-all-democratic military reactors around the world seem to be doing fine.