The bottom line is the nastiest stuff in spent nuclear fuel are the actinides. They're all naturally radioactive and most of the stuff with long (10,000+ year) half lives that requires long-term storage. You need Yucca Mountain mostly for the actinides. If instead you smash them with fast neutrons you can get them to fission, releasing some energy (though sub-critical) and transmuting them into either much more stable isotopes (little radioactive decay) or really unstable ones (nasty but they decay so fast you only need to hold onto them for a few days/months/years).
The short version is besides reprocessing spent fuel we should be putting the nasty stuff through the sausage grinder again to turn it into much less nasty stuff instead of fighting over where to keep the nasty stuff safe for 100,000 years.
Yucca mountain has been designated as the long term storage site since 1987 by Congress. Every change of party majority since then has either stopped or restarted work on it.
I'm also personally still concerned about transportation accidents resulting in permanently contaminated areas.
[1] https://www.posiva.fi/en/index.html
As for transportation, this has been a big concern for some time but has pretty rock-solid technical solutions [2]. We regularly ship high-level nuclear waste around (e.g. from nuclear submarines to Hanford) and haven't really had any incidents. I'd claim that the issue is basically solved with these robust containers.
There's only a tiny amount of high level nuclear waste.