Very different take on rain, but there's this segment of The Last of Us 2 where you're in the middle of a giant storm, with intense rain and giant waves battering the place you're sneaking into at the time - incredibly immersive and atmospheric.
Given the story context and what happens during that bit, I thought the way they used the weather in that segment was just *chef's kiss*. Horrifying, but *chef's kiss*.
Things spiral out of control at that point, with the storm reflecting everything falling apart.
Thinking about it, I'm kind of shocked that neither Thief nor Dishonored ever had a really good, spooky rainswept infiltration mission - or at least not one I can remember - seems like a perfect fit for an immersive sim to me. Atmosphere-wise, I mean.