Yes, you're right that all of the problems mentioned above are related to the installer. I didn't try to hide that and even used the word 'installer' in two of the four headings. I can see how you'd think that the title is misleading, but in the end you can't separate spray foam insulation from its installation. Some people have the mistaken impression that if you get spray foam in your house, your home will outperform all others. My point here is that that's not true.
Spray foam is a fully adhered insulation that is spray applied into wall cavities, providing a continuous air and moisture barrier. Spray foam allows efficient use of your HVAC system and helps regulate the temperature fluctuations and humidity in your home. Spray foam effectively seals the building envelope, filling in any cracks and crevices, the common source of air and moisture infiltration as well as temperature variations.
A. You can use closed-cell spray foam that way if you want, although you should realize that the spray foam will prevent the roof sheathing from drying inward. This approach should only be used if the roof sheathing is bone dry, because it will never dry when sandwiched in this manner. Most building scientists would prefer to see fiberglass rather than closed-cell spray foam under the roof sheathing in this type of assembly.

Roof Coating Seal