The issue with spent fuel has to do with the long term (essentially permanent) storage part and is purely political. It's a solved problem except for getting approval for the solution.

The other fuel issues you mention are already dealt with today as a matter of course. It's just the final part that remains up in the air.

You are the one hand waving about failure modes. As with aircraft, as failures have happened we've learned from them. New designs aren't vulnerable to the same things old ones were. All the mishaps have happened with old designs.

Personally I think the anti-nuclear FUD that the climate activists push is unfortunate. We would likely have been close to carbon neutral by now if we'd started building it out in the late 90s.

That said, I'm inclined to agree that solar might be a better option at this point in environments that are suited to it. The batteries still aren't entirely solved but seem to be getting close. In particular, the research into seasonal storage using iron ore looks quite promising to me.