Most recent time I was awestruck by a thunderstorm in a game? Forza Horizon 5. One of the early missions involved heading out in the jungle during a massive thunderstorm and it was just legendary. Visuals, audio, everything.