I had a hole in the drywall in our bathroom that was about 2 in x 5 in that I used Great Stuff to fix. I am impressed with the characteristics of the filler. It filled the hole completely in a few seconds of application. I will warn anyone using it though to make sure you don't fill the hole entirely flush to the wall because this stuff continues expanding after you apply it. I didn't think about that but no big deal really because you can sand it which is exactly what I did, and then applied spacial and paint and it is almost as good as new. For the price this was a heck of a deal because I only used a tiny amount and now am left with nearly a full can. I guess I will have to find somewhere else to use it now. Great product, ... full review http://youtube.com/embed/ggLAUsiuI_o
Jennifer, I'm not an expert on the health effects of closed cell foam. A lot of people live in houses with closed cell foam and have no health problems from it, at least not short-term, acute problems. I do know of one person who had it removed from her crawl space because she was convinced it caused her dog to get sick, but I know only what she told me.  

I don't even want to ask this question but... several years ago we hired a local contractor to spray high density foam on the roof deck and walls of our unfinished 2nd floor. We realized that the job was done poorly and cut an access into the attic space to assess things. We realize now that they spray foamed directly to the chimney (no flashing). The chimney is currently used for a woodstove and DHW venting. The DHW will go away but wood stove will remain. My question is, how bad (unsafe) is this? I have found information on foam exposure to fire but have not been able to find anything about temperature ratings in general (i.e. what happens on prolonged exposure to high temperatures).
Light-density open-cell SPF is commonly known as half-pound foam. It is a semi-rigid material with a sponge-like appearance that expands during installation and creates small, open cells that are filled with carbon dioxide. Due to its ability to expand during the application process, it fills cracks, crevices and voids and adheres to irregular surfaces or substrates to form an air sealing insulation.[12]

Where Can I Purchase Spray Foam Insulation

If you cut the nails holding one of the corner studs to the bottom plate and the top plate with a Sawzall, you can use a flat bar (or a flat bar plus a wrecking bar) to pull the stud off the sheathing nails. Either re-use the stud, or buy a new stud, and install the stud with toenails as shown in the link I provided in Comment #51 (this link: Outside corner detail).
During colder months, 2 component foam is very sensitive to temperature variances. Per product instructions, both tank temperatures need to be above 70°F (21°C) for at least 24 hours prior to use. All application surfaces should be clean/dry and above 60°F (16°C) prior to application. Variance outside of the recommended temperature can affect foam yield and performance.

Roof Spray Foam Insulation