I guess off topic, because water isn't weather, but Wave Race 64 absolutely stunned me with the water and impact to gameplay. Just stunning, and kind of sad that other games haven't reproduced said water impact.
I don't know how to post gifs, but Tsushima had great weather effects.







