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).
The average price to cover 200 square feet with a foam insulation kit will run between $300 and $600 (about two to three kits). Inside these kits is something called Icynene, a foam made from two liquids that are heated and pushed through a gun on the can. When Icynene is released, it expands up to 100 times its size as it hits the surface area you're covering. These can contain a lot of gasses, making its installation a dangerous process. Even low-pressure sprayers can be harmful to homeowners' health.
Before you decide on spray foam or another method of insulation, it's important to understand the superiority of spray foam compared to traditional materials. When compared to fiberglass batts, spray foam offers nearly double the R-value per inch, achieves air-sealing and insulation in one step, won't be damaged by mold or moisture, and won't settle, compress, or otherwise be damaged to the point it needs replacement.