So I started my first playthrough with Dolomite Weathers and Forest Borealis - here's a crap video I made, but it showcases the weather diversity fairly well: skyrimmods
Vivid Weathers Definitive Edition - a complete Weather and Visual overhaul for Skyrim at Skyrim Special Edition Nexus - Mods and Community
Dolomite Weathers - Natural Lighting Vivid Atmospherics II at Skyrim Special Edition Nexus - Mods and Community
Skyrim SE Dolomite Weather and Surreal Lighting - YouTube
Better Dynamic Majestic Mountains at Skyrim Special Edition Nexus - Mods and Community