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.
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.