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
Fill and seal expanding foam sealant is urethane Fill and seal expanding foam sealant is urethane foam designed to fill large areas quickly and permanently. Uses include filling holes cracks or gaps that require a complete airtight and waterproof seal but are too large to be filled with ordinary caulk. The foam expands approximately 3 times its original ...  More + Product Details Close http://youtube.com/watch?feature=youtube_gdata&v=ggLAUsiuI_o
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). http://youtube.com/embed/ggLAUsiuI_o

In general, cantilevered steel beams are a nightmare. If part of the steel beam is in contact with exterior temperatures, then it's best if the interior portion of the steel beam is covered on all sides with insulation. This is generally impossible (because the interior portion of the cantilevered beam generally supports a load, meaning that you can't wrap the steel beam in insulation on all sides).

How Much Is Spray Foam

Steve: If your spray foam installer leaves the vents open, he will be committing the 2nd of the 4 problems I described above. You will most likely have comfort and efficiency problems. You may well have condensation problems. You will be spending a lot of money on a product that likely won't perform as it should. Don't let him leave the vents open. If the installer you've chosen doesn't understand this, you may want to choose someone else.  

SPF application is fast and effective. Unlike traditional insulation types like fiberglass, which require a separate air-sealing step, spray foam can air seal and insulate a structure in one step, thus keeping the project moving forward. Combining these steps coupled with a spray-on application decreases installation time and delivers the ability to fit into hard-to-reach places, like eaves, odd-sized cavities, and rims. In addition to installation efficiencies, spray foam can provide excellent thermal, acoustical and indoor air quality performance in any climate. 
This stuff works GREAT ! I live in an older mobile home that had a lot of leaks when I moved-in. I worked for two years to locate and fix them all. Now I simply go over all of the repaired places once a year just to be sure everything is OK. NO LEAKS FOR 4 YEARS NOW!!  Others here use "sno proof" or something that does not stop leaks. When I tell them about my success, they don't seem to want to pay the$ for this superior product. Too bad!. I used the tape in  repairing the leaks.
Spray foam insulation, when properly installed is both an air barrier and when closed cell foam is used at the proper depth a vapor barrier!  Before hiring any contractor you should establish the brand of foam being used and verify that with the named manufacture.  Please ask for ESR reports and MSDS sheets on any foam being installed in your home. A couple areas where you might consider spray foam insulation include:

Where Can I Buy Closed Cell Spray Foam