No, I haven't dealt with radioactive substances beyond what's found in ordinary households. But I'm not a complete ignoramus as you imply. Have
you at least done a search on how much non-radioactive waste there is? Spoiler, it is a much, much,
much bigger number. I think this is another case where the relatively small number on the nuclear side makes it scarier because it's something you can actually conceive of.
No, I don't want it in my back yard. I'm not arguing that it's harmless. But it's not that big of a deal, compared to mercury, arsenic, PFAS, etc., etc.
My go-to comparison is seafood. Look up the advice on how much to eat, and it'll be, have some, but don't have too much, especially for more vulnerable populations like children and pregnant women. Why? Because pollution of the seas is so prevalent that it's bad for you to eat a lot of it. And while nobody is out there saying this is wonderful and we should pollute more, the response to this is pretty weak, and people mostly shrug their shoulders and get on with their lives. At the same time, we had people freaking the fuck out because the most sensitive instruments were able to detect a tiny bit of Fukushima contamination on the US west coast.
I don't mean to completely trivialize nuclear waste, but the concern about it is deeply out of proportion compared to how other waste is viewed. And yes, at least some of that discrepancy should be made up by being more concerned about other waste.