In other words, the more harmonic components there are that interferes with each other, the more localized your spatial distribution is. The fewer interfering components there are, the more spread out it is.
At the classical limit, we assume there are practically infinitely many interfering components, with all of free space as the resonance length. Ergo we have perfect localization
At the quantum scale, interacting components are few and the length scale is highly constrained, ergo we get very spread-out (due to having few overtones) and quantized (due to small resonance length) position wavefunctions.