I saw this thread the other day, which piqued my curiosity since I had the same problem with my spillover. I have a great cascade when the booster pump is running, but with just the main pump, I get a small cascade on half of the spillover, and the rest dribbles down the wall.
Well, I'm not going to go out and make any sort of recommendation to you, however today was the day I added borates to my pool. I added 25 lbs of boric acid. Within minutes of pouring it in, I noticed something surprising from my spillway. A full freaking cascade! What???
Seeing is believing:
Besides actually having a full cascade on the spillover, I've also noticed that it's quite a bit less turbulent, and thus less noisy. I don't know, maybe I'm just imagining things? Maybe it's the after-work beer? Or maybe just the SoCal sunset:
Anyways. As for possible explanations? I've read others noticing a high lubricity of the water. It's possible that this is resulting in a slightly higher surface tension in the water, causing it to stay more uniform as it flows over the lip of the spillway. But what do I know? I'm a software engineer, not a physicist!