Is closed cell spray foam worth the money?

Closed-cell spray foam is the Best of the insulations when it comes to both R-value per inch and cost. Nothing else comes close, really. Unlike its open-cell, closed-cell spray foam is not vapor permeable and will not hold water. This makes it an excellent option in case of water intrusion