I find this to be the most frustrating aspect of the nuclear discourse. The "waste problem" is technically solved (we believe, gotta wait ~10k years to know) in a way that depends on a social solution that doesn't seem to exist. Pro-nuke people will handwave it away, ignoring the total failure to secure storage sites in most places, and the anti-nuclear people treat it as a fatal flaw in the technology (which it isn't).

That said waste storage is, arguably, the only problem that matters for nuclear power today. Every stage is expensive and controversial: on site storage, transport to long term storage, long term storage. As for "[n]o company or reactor could ever leak into the community in a covert way" you're right in the sense that, if you're testing your water daily for tritium you'll catch it, but how often does that happen? You can refer to the official list of US leaks[1] to see how many of them have months attached to the dates - often with high values!

The point is that all industrial processes are easy to safeguard with sufficient testing and oversight. But the challenge of communicating that (and then actually implementing such a system) are substantial and historically unsolved. Consider, if you will, the discourse around the JCPOA with people insisting the Iranians would cheat. "How!?" you, an informed reader, might ask - but again we are back to convincing people of the sufficiency of technical solutions they do not have the background to solve. It is a very hard problem that is arguably harder than nuclear engineering (a problem we've made considerably more progress on in the last 70 years).

[1] https://www.nrc.gov/docs/ML2432/ML24320A014.pdf