These songs about rain are flooded with emotion, from romance to doom