I've only experienced clear, foggy, and partly cloudy weather since the rollout so I haven't noticed the visual changes much, but so far I'm really enjoying the weather effects on spawns and the bonus stardust for weather-boosted pokemon, it's like there's a constant mini-event.