Guns N' Roses - November Rain
Garbage - I'm Only Happy When It Rains
Jane Siberry - It Can't Rain All The Time (from The Crow soundtrack)
These aren't weather exactly, more weather related but:
Scorpions - Rock You Like A Hurricane
Live - Lightning Crashes