You want to look at the type of foam used and make sure you have the right selected for your application - there is a difference between closed cell and open cell.
I used a couple of DIY kits on the gables in my attic - easy to use, worked exactly as they said they would. Getting the right coverage per spray took a little getting used to, but overall it was not much of a problem. The biggest headache for me was getting the tanks up in the attic - they are not light and it was a pain for me to get them to each side of the attic without falling through while balancing on joists.
The gables in my house were uninsulated - during the summer you could feel heat radiating from them (especially on the west side) from as far as 10 feet away. I used an open cell DIY kit (1200 board feet at 1" IIRC) on each gable. Made a huge difference in the amount of heat that gets radiated into my attic.
I'd love to do the underside of my roof deck, but that's more than I'm willing to spend.
One thing about doing a roof deck - you need to make sure your AC gets evaluated after the fact. What generally happens is that the insulation is significantly more efficient than standard batt insulation (which I wouldn't remove BTW) that your AC becomes inefficient - mostly because it suddenly becomes oversized and does not run long enough to pull moisture out of the air like it is designed to do.
Edit - Bought my kit at Roofing Insulation & Supply on the north side of town.
Website