I use substance designer regularly for all my textures needs since 2 years now, flare, dust, noise, impact crater and threshold maps. I have the chance to be really free to try new things on production and have time for this.
I built small tools for snow wave/sweeping on ground and I was able to iterate quickly my flipbooks thanks to Bruno tools !
I even used subtance for explosions flipbook for normal map tweaking.
Just the fact you can preview the texture tiling just by pressing spacebar in 2D view is a blast for me.
I think its a good start to switch your brain into procedural thinking.
I admit its hard to get away from photoshop at first, but it like any package and get out of your confort zone. But the speed you gain from iteration is tremendous.
My ultimate goal is to have handpaint blizzard style but procedurally. I’m pretty sure its doable with enough tries 
Here a substance I did :
substance file
Be sure to have @Bruno 's altlaser !
Will post the snow crawlings in the next days.