Well of course my favourite would be
It's raining men ~ The Weather Girls (best version)
It Might as well rain until September ~ can't remember who by
I Can't Stand the Rain ~ by a soul diva I can't think of.
Trouble is with a lot of the rain songs they are linked
to being unhappy and you don't need too many at once.....