I foresee fusion though, ultimately. I think it mostly solves the nuclear waste "problem" and should promise huge cheap energy, I'm excited by some outlandish things which could become feasible if electricity is truly cheap.
And it's true that the sun shines about 100 PW, or 5000x humanity's total energy usage (≈20 TW) on the surface of earth on a nice day.
Even if you assume that the fusion part is cheap, you still have to convert the energy to electricity or at a minimum mechanical work (unless you're using the process heat, which is admittedly a possibility for a fair bit of current demand).
Steam turbines aren't exactly cheap to build.
Yes, there are alternative energy conversion possibilities for some possible fusion fuel cycles, but as I understand it those fuel cycles are much more difficult than D-T fusion and therefore are even further away from being a practical power source.
I'm also personally still concerned about transportation accidents resulting in permanently contaminated areas.
[1] https://www.posiva.fi/en/index.html
As for transportation, this has been a big concern for some time but has pretty rock-solid technical solutions [2]. We regularly ship high-level nuclear waste around (e.g. from nuclear submarines to Hanford) and haven't really had any incidents. I'd claim that the issue is basically solved with these robust containers.
There's only a tiny amount of high level nuclear waste.
Yucca mountain has been designated as the long term storage site since 1987 by Congress. Every change of party majority since then has either stopped or restarted work on it.
The bottom line is the nastiest stuff in spent nuclear fuel are the actinides. They're all naturally radioactive and most of the stuff with long (10,000+ year) half lives that requires long-term storage. You need Yucca Mountain mostly for the actinides. If instead you smash them with fast neutrons you can get them to fission, releasing some energy (though sub-critical) and transmuting them into either much more stable isotopes (little radioactive decay) or really unstable ones (nasty but they decay so fast you only need to hold onto them for a few days/months/years).
The short version is besides reprocessing spent fuel we should be putting the nasty stuff through the sausage grinder again to turn it into much less nasty stuff instead of fighting over where to keep the nasty stuff safe for 100,000 years.