I really liked the storms in Valheim. Probably not the best looking but they felt so impressive.

This channel has a lot of pretty game ambience, but isn’t limited to storms.