The video game that first came to mind was the opening segment of Metal Gear Solid 2. Something about the rain in that first part of the game was done perfectly. I've placed a video of the opening scene below.

https://www.youtube.com/watch?v=Ukh7C9zkXGc