Ideally it would be. But in many cases in practice, that isn't the case, because those facilities have either not been built, or not opened. In the U.S., since the long-planned Yucca Mountain facility has never opened, most nuclear waste is stored on-site at the reactor complex, in above-ground facilities. For the first few years it's immersed in cooling pools [1], and then subsequently is parked in metal/concrete cylinders [2]. This is considered interim storage awaiting final burial in geologically stable vaults, but without Yucca Mountain the "interim" storage has become de-facto permanent.
So now the plan is to retrieve all the waste and store it - this time better at an estimated cost of at least 4 - 6 billion Euro.
The general problem I have with nuclear power is that it's all fine and dandy as long as everything goes as planned. If not, then everything goes boom in a big way. And where humans and profits are involved, plans tend not to involve all failure modes: The explosions in fukushima could have been avoided using catalytic recombinators which are for example mandatory in germany [1].
[1] http://de.wikipedia.org/wiki/Reaktorsicherheit#T.C3.B6pfer-K... (sorry, german)
Don't forget that uranium is found naturally in the ground, in geologically vastly more unstable regions, with water flowing through it. What we're doing is concentrating the radioactivity, and putting it deeper and safer. If you're afraid of mankind finding these waste sites in the future, are you not afraid of them finding uranium in their drinking water?