Pretty much all of the songs on Disintegration qualify. Even the less well-known ones, like Pirate Ships and Homesick, which are agonisingly beautiful.
The ironically titled "Boys Don't Cry" as well, also a case of Lyrical Dissonance.
"Cut Here" might make one sob like a little girl.
"Want" is about no matter how hard you want something, it'll eventually become worthless. The guitar riff doesn't help either.
And There Is No If. If you're happy when you hear it, it makes you sombre and reflective. If you're sad... well God help you. "Hysterical grief" doesn't even cut it.