Good question! Since you asked: it is largely in cooling pools and piling up in empty lots around nuclear power plants, waiting for safe, secure storage to appear.
> Something is either highly radioactive for a short amount of time, or not very radioactive for a long amount of time.
This is not true at all, unless you consider "short amount of time" to include decades to centuries to millenia.