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

How Much Is Spray Foam Roofing

2. I talked to a building product supplier for WALLTITE spray foam, he is suggesting to use 2" or 3" of closed cell spray foam in the joists areas instead of the batts insulation. He says it will work with outboard rigid insulation. There is a location of a cantilevered floor area with steel beam so I may need to use spray foam to protect the steel beam. I would then be convenient continue to spray in the floor joist cavities and then apply 5" of polyiso outboard of the bottom cantilever floor sheathing.

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. 
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.
I've seen this only once, and it was with closed cell foam, but I've heard of it happening with open cell foam, too. I don't know the details, but I've heard it could result from a bad batch of chemicals, improper mixing, or too high a temperature. Whatever the cause, it's not a good thing. The photo below shows how the spray foam pulled away from the studs. A little bit of uninsulated area like that adds up to a lot of heat loss/gain when the whole house has that problem, as it did here.

How Much To Spray Foam A Shipping Container

Also, I'm wondering... Is this website is being regularly updated? A local installer (in Oct, 2010) in MA quoted over twice the price you list here. "Open cell alone ~$1.35 per sq ft for R-13. Or a 'hybrid method' using 2inch closed cell for R-13 followed by 1.5inch open cell for R-6. Hybrid is $2.85 per sq foot for R-19 rating". Maybe installers are charging higher prices to profit from those trying to meet government energy rebate by Dec 31?

How Much Is Spray Foam Insulation A Square Foot

Most flat roofs are not perfectly sloped, causing water to puddle in some areas, in particular around the drains and scuppers. Many roof coatings are not rated or warranted for "ponding water", and thus might fail pre-maturely if exposed to standing water over long periods of time. Serious consideration should be given to the performance and limitations of the coating being selected. Some manufacturers will warranty their coatings including ponding water. Typically, manufacturers for acrylic roof coatings do not include warranties for ponding water, while some polyurethane and silicone roof coatings manufacturers will.
United Coatings™ Roof Coat Elastomeric Coating is an effective coating for providing long-term reflectivity over a wide range of roofing substrates. The high reflectivity of Roof Coat Elastomeric Coating keeps the roof substrate cool, which not only helps prolong its longevity but also helps save on energy costs. Roof Coat Elastomeric Coating’s rich consistency uniformly covers the textured profile of various substrates, forming a flexible monolithic membrane that provides protection from normal weathering, aging, and ultraviolet exposure.
Roof Coatings should not be confused with deck coatings. Deck coatings are traffic bearing - designed for waterproofing areas where pedestrian (and in some cases vehicular) traffic is expected. Roof coatings will only waterproof the substrates but will not withstand any kind of on going use by people or vehicles (such as walkways, patios, sundecks, restaurants, etc.).

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