I'm not opposed to nuclear. I think it needs to be a viable option if we are to stop producing CO2, but I won't pretend that it's harmless, either. Even if we get to a 100% safety record, there's still the matter of storage, and transporting that waste to the storage areas. How many TEPCOs do we need to realize many of these companies entrusted with the task can be very incompetent and borderline criminal in ignoring safety lapses pointed out by inspectors.
You're not opposed to nuclear, but you still fall prey to the severe lack of knowledge most people have regarding nuclear power generation. It's really simple: if the waste is so dangerous as to need storage that can last centuries, as is currently the case, it's because it's overwhelmingly still fuel. It's been "poisoned" in the reaction process, but can be reprocessed into usable fuel. However, the US has stopped all reprocessing activities, which means that the fuel is immediately disposed as soon as its efficiency dips too much. While studies say that reprocessing is more expensive than just getting new fuel, this wouldn't hold if we refocused on nuclear power, making recycling an obvious choice. Further, certain designs of reactors can straight up use the poisoned fuel anyway, lasting dramatically longer and producing far less dangerous waste, since more of its energy has been extracted. That's discounting thorium reactors, which don't even use uranium and produce up to 100 times less waste than uranium-based reactors.
In essence, the waste issue has by and large already been solved (or at the very least dramatically diminished) by scientists. It's just politicians getting in the way.