A lot that I first thought of have been mentioned
Would also add (I don't think I saw these):
Blue Eyes Cryin in the rain - Willie Nelson
Fire and Rain - James Taylor
I Wish it Would Rain Down - Phil Collins
The Rain In Spain - My Fair Lady
Sunshine After the Rain - Berri
Blame it on the rain...