Spray foam insulation is a great product. Homes insulated with it can be some of the most efficient and comfortable homes built. I've been in plenty of these homes and can tell you that when spray foam is installed properly, they outperform 99% of fiberglass batt-insulated, stick-built homes. (I can also tell you that 73% of all statistics are made up on the spot, so please don't ask for documentation of that statistic.)
Although spray foam insulation has been in use since the 1940s, primarily for aircraft, for the past 30 years, continual product innovation has seen the increased adoption of spray foam insulation in residential and commercial construction. The rapid growth of sprayed foam insulation in building construction, thanks in part to its immediate and long-term benefits, has allowed the insulation material to sit confidently alongside traditional insulation types in providing thermal comfort for building occupants. http://www.youtube.com/watch?v=ggLAUsiuI_o&feature=kp
I have never used foam insulation before and this was easy for me to use right out of the box. I had a 4'x8"x8" cavity in my basement that houses a waterline. When the previous homeowner installed this they put no insulation in at all and being that it's an exterior wall in the basement and I live in the Midwest that thing was pushing so much cold air in it was incredibly uncomfortable. Out of the box and job completed in about 5 minutes. Stopped all drafts and created a nice 2" barrier on the wall in which I will install some extra bat insulation over it. 4 stars because the spray isn't very good passed 6-8" from the surface. Make sure you can reach the surface you want to coat. Great for small jobs!
We have a 1950's ranch in Atlanta and are interviewing foam contractors to spray open cell under the roof, with an "ankle wall" out towards the eaves to seal the attic. My wife and daughters are chemically sensitive, so I'm trying to figure out how to minimize the fumes coming into the house. Additionally, at least one contractor has offered (for > $900) to remove our existing rock wool & R-13 fibreglass from the attic floor to "increase cross-ventilation into the attic". Seems to me I can't both minimize fumes AND increase cross-ventilation. They also offered to spray a fire-retardant on for >$600. Would ventilation during installation help any or woud the retardant seal off the foam and help that way? Thanks...
It also has a great waterproofing ability that can shield the roof’s membrane from water and moisture damage. You can also count on the liquid roof coating for its outstanding performance for a wide range of applications and uses. This product can be used at tears and seams as well as in sealing air conditioners and venting systems and anywhere else where rubberized coating is needed.

Spray Foam Roof Insulation