A fair warning up top: my mind is very much made up about this. The risks of nuclear power generation from feeding the grid until the radiation mess has half-lived itself into harmlessness are too great in my opinion. And that's what this is. My opinion. I suspect yours differs. If you keep reading, you'll probably get the feeling that there isn't anything you can point out that gets through to me. Because, truthfully, it doesn't.
It’s a very small amount that can be contained in secure casks and concentrated in a particular secure location in the middle of nowhere ...
In my opinion, this is the waving away bit I referred to earlier. Europe doesn't have a "middle of nowhere." There is no such thing as a "secure location." There is at best one with slightly reduced risks. There are people spread out everywhere, you're going to end up in somebody's backyard who doesn't want it there. You need to be very careful that this stuff doesn't escape its container and seep into groundwater. And this needs not to happen for a minimum of a century. You're not breathing in the fumes constantly, sure. That's why it's better than a coal plant. You're risking radiation leakages over a very long time for future generations, should we survive this as a species. It's human hubris to say we can engineer around this threat on a scale of centuries.
A significant number of inland plants are built close to rivers for the perceived ease of getting the water. We just need one of them to fail unexpectedly to have a big problem. I'm not sure using groundwater for cooling is a great idea for much the same reasons as it isn't for data centers. We need to manage our water resources, especially drinking water, as Europe heats up. We need to plan for a time when there is no "surplus water." And damming up rivers is expensive and the benefits of that to the environment are limited. If we go to these lengths to preserve a nuclear fission plant we might as well built a solar farm and a wind farm.
I understand that emissions-wise nuclear fission is a great way to avoid those and it thus beats burning fossils. It's still more of a "the plague or cholera?" kind of choice between them. If everything around nuclear power plants is that great and nothing to worry about, why Three Mile, Chernobyl, and Fukushima? It's the hubris of we've got forces much more powerful than us under control. Until we don't. We've thought of everything! Until we find out we didn't. You put all of this together and that's why I think fission is a stop gap technology we should phase out completely - drastically, at the very least.