Polyurethane is a closed-cell foam insulation material that initially contains a low-conductivity gas in its cells.[5] As a result of the high thermal resistance of the gas, spray polyurethane insulation typically has an initial R-value around R-3.4 to R-6.7 per inch.[5] In comparison, blown fiberglass typically has an R-Value of only R-3 to R-4 per inch.[6]
I have been looking to have closed cell insulation added through out my attic space. I cant seam to find a installed that wants to install no more than 2 inches, and thats not near my R-valve for South Carolina (Lake Greenwood)please send any advice that will help me to see what installer will perform the correct job. This is a expense that i can only afford to do once. Sandi

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.  
If your foam pulled away just a little bit, Jamie, and they were able to fix it with just a little bit of touching up, then it wasn't as bad as the house where I saw this problem. As the last photo above shows, it had pulled away significantly from the studs and rafters, and it was all over the house. This was closed cell foam, and interestingly, it didn't pull away from the horizontal framing members, just the vertical and sloped ones. They did some touch up, but that wasn't enough. I don't know how this one ended up getting resolved. I think maybe the contractor came back and sprayed cellulose on top of the foam.

Roof Coating Denver Colorado