Most closed-cell spray foam is now formed using hydrofluorocarbon (HFC) blowing agents that have high global warming potential, partially or completely offsetting the climate benefits of the energy savings they can offer. In the United States, HFCs are scheduled to be phased out by January, 2021. A few spray foam suppliers have started supplying spray foam blown with hydrofluoroolefin (HFO) blowing agents without this problem as of early 2017.
Spray polyurethan foam does effectly prevent all six of these heat transfer methods from occurring. These should be the mechanisms by which you judge insulation, in addition to their R-Value. If you're uncertain about installing spray foam insulation, Energy Star has a map that recommends levels of insulation by R-value and cost-effectiveness in the United States. https://www.youtube.com/watch?v=ggLAUsiuI_o&app=mobile
Sealection® 500 has been Demilec's flagship product for more than 20 years, and has positioned Demilec as an industry-leading spray foam insulation manufacturer. As an environmentally-friendly product, it delivers superior performance, energy savings, and is an excellent return on investment for architects, builders, contractors, and homeowners, making it the ideal choice for insulation. https://www.youtube.com/watch?v=ggLAUsiuI_o&app=m
The problem was that the installer was doing his first spray foam job ever, and the thickness of the insulation varied from zero (visible roof deck) to about 9". Unfortunately, good average thickness doesn't cut it. The coverage needs to be uniform because a lot of heat will go through the under-insulated areas. (See my article on flat or lumpy insulation performance.)