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).
Global warming potential (GWP), as defined by the EPA, is a measure of how much energy the emissions of 1 ton of a gas will absorb over a given period of time, relative to the emissions of 1 ton of carbon dioxide (CO2). Spray foam insulation products that use water as the blowing agent - typically open-cell foam however Icynene’s ProSeal Eco is a 100 percent water blown closed-cell spray foam – have a global warming potential of 1, the lowest possible number. This is because water in the mixture reacts during the application process to release carbon dioxide and heat. The GWP of the blowing agent is that of carbon dioxide. Carbon dioxide has a GWP of 1. https://youtube.com/watch?feature=youtube_gdata&v=ggLAUsiuI_o
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: http://www.youtube.com/v/ggLAUsiuI_o&feature=youtube_gdata