Once nuclear waste has aged for a while the main radiological threats are a few fission products with a half-life around 30 years (Cesium 137 and Strontium 90) and then some transuranics (Plutonium 239) that have half-lifes more like 40,000 years.
Thus if somebody dispersed spent fuel in the environment it would not create mass causalities that would kill or injure combatants but instead there would be a concern that it would cause health problems for random individuals over a very long time.
I'd compare that to a dirty bomb which is probably not that much deadlier than a plain bomb (if you had material that was dangerously radioactive enough to harm the public the bomb makers would be killed by it) except that people who are near it might suffer psychologically because they imagine they might get lung cancer because they inhaled plutonium particles.