The problem you saw with the closed cell foam pulling away like that is due to the heat of the foam was to hot. It was actually curing out and making foam before it could adhere to the wood. The installer wasn't reading his foam correctly. He should of stopped and turned down the heat on his hose temp. Also installers have to be aware that as the sun rises and the temp in attics rises the subtrates get hotter as well. This will cause the installer to adjust his heat when installing the foam as the temp changes thru out the day.
While coatings may potentially stop minor leaks, the roof should be properly repaired and dried prior to coating application. Coatings may be able to seal pinhole leaks, which are leaks not visible to the naked eye. If the roof is leaking, the roof leak will need to be identified and repaired prior to any recoating; do not expect the coating to find and seal the leaks.
Closed-cell (aka two-pound foam) is denser than open-cell at about 2 pounds per cubic foot. Its R-Value is between 6-6.5 per inch. As a result, this kind of foam is much more expensive than its counterpart. The reason closed-cell doesn't need a vapor retarder is because it already has one. It's permeance is 0.8 perm, which means it can handle cold climates without the use of an additional board or drywall. Closed-cell uses hydroflurocarbons (HFCs) as part of its makeup. However, this material has been known to have a high global warming effect. If you want a green insulation solution, this is not the material to use. A way to avoid this and still use closed-cell is by installing it alongside fiberglass batts.
Product innovation over the years has seen the introduction of several different types of spray foam insulation. Primarily in residential and commercial construction, open-cell and closed-cell spray foam is used while high-density spray insulation is used as roofing foam in commercial or industrial construction. Open-cell sprayed-in foam insulation, a soft low-density material, is typically used for interior applications such as wall cavities, underside of roof decks, attics, basement walls and crawlspaces. The open cell structure of low density foamed insulation allows for moisture permeability to help contribute to moisture management and bi-directional drying of the wall assembly. http://www.youtube.com/watch?v=ggLAUsiuI_o&app=desktop
I recently did a remodel project for my basement using spray foam insulation. The original builder has used fiberglass, but I wanted the best insulation i could find. We chose closed cell foam because it blocks moisture from getting into the house. It took one day to install and was fumey for about 3 hours. It was pretty cool watching it being done. It comes out as a liquid and then expands rapidly into a foam. It's quick! Then they took a types of saw to shave it flat with the wall studs so we could then go ahead and drywall.
Spray Foam Tanks
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
I don't know if it's common or uncommon, but installing a layer of rigid foam above your roof sheathing in order to interrupt thermal bridging is always a good idea, and is preferable in all respects to a roof assembly without any rigid foam above the sheathing. If you decide to install rigid foam above the roof sheathing, you shouldn't use closed-cell spray foam under the sheathing; either use open-cell spray foam (which is vapor-permeable) or a fluffy insulation like cellulose, mineral wool, or fiberglass (any of which will allow the roof sheathing to dry to the interior).
It also has a great waterproofing ability that can shield the roof’s membrane from water and moisture damage. You can also count on the liquid roof coating for its outstanding performance for a wide range of applications and uses. This product can be used at tears and seams as well as in sealing air conditioners and venting systems and anywhere else where rubberized coating is needed.
Spray Foam Roof Insulation