Typically, back when I did wx mod, we concentrated on snowfall enhancement in California. This was done for two reasons; a) increased snowfall equals more tourism especially in the Tahoe area and b) more snow means more water in the spring. More specifically it was easier to find funding for the winter projects if you could show that you were killing two birds with one stone. Further... You may not hear about it a while heap because there are a lot of Enviro-crazies who think wx mod is a method of poisoning Americans or doing damage to the environment. Chem Trails anyone? Sometimes it is just better to be low key when your cargo is a DOT explosive.
And as to it's effectiveness... My knowledge is a little dated but it varied from slightly effective to very effective.