I really like the rain in Halo: Reach. I was kind of stunned how natural it looked - and it really surrounds you with sound in 5.1.
Also, the rain in Gears of War.
And as far as clouds - Spoiler alert!
The clouds change in that city you fix up in Assassin's Creed II are quite impressive.







