I bought some atmosphere aerosol a while ago and did some video tests with it.
The thing with this spray is that it is nothing like a smoke bomb which creates billowing smoke that is obvious from the front. It works best when back-lit. I did a shoot for a bodybuilder on the weekend and here's a 'normal' picture with bounce flash.
And here is another shot with the flash behind the subject and some atmosphere aerosol spray in the air. Very different results.
So if you're looking for a smoke-bomb effect you will be disappointed but if you use it the way it is meant to be used it can make for some very interesting photos.