Canada

I'd assume that "geologically stable" was one of the requirements when they first made a list of potential locations.

Fortunately, all of the heavy-water CANDU reactors currently in commercial service in Ontario are fueled by unenriched uranium, so the worst possible outcome shouldn't result in much more contamination being released into the environment than we would see with a natural uranium deposit of comparable size nearby. Which isn't nothing, but the result would be a smallish statistical increase in cancers, not people dropping dead from Acute Radiation Syndrome. Many industrial sites do more damage and are less scrutinized, but we get all weird about radiation the moment the word "nuclear" comes up, and have a hard time putting the risks in perspective.

These aren't bins of glowing green ooze like in the cartoons. Most waste products are solid and are stored in heavy duty, shielded bins. Kyle Hill on YouTube created a really good video that demonstrated walking through a storage facility and literally hugging one of the bins. His rad meter was perfectly normal the whole time. He also examines other risks as well as the risks of other methods of power generation.

Video for reference: https://www.youtube.com/watch?v=4aUODXeAM-k

Here's the one where he hugs the waste casks:

https://www.youtube.com/watch?v=lhHHbgIy9jU