Breath of the Wild is the first game i’ve ever played with random sun showers and rainbows. They are as gorgeous as you’d hope. It also has legit terrifying thunderstorms, with lightning striking all about you (and possibly striking you if you’re equipped with metal weapons, or are even standing near one!). If you see one off in the distance, you can watch it dissipate in real time.
There is also the beginning of this game, which i’ve loved since i was a kid:
(skip around a bit within the first 10-15 minutes or so and you’ll see it. but first watch that cutscene to hear the beautiful music and see a video game main character make out with his pregnant wife)