Open-cell is the lower-priced foam, and it quiets a room much better than closed-cell foam, the dense kind that blocks moisture. The catch is that open-cell lets moisture vapor pass, so it can't be the layer that slows moisture moving through a roof or wall. We talk through whether that matters in the spot you want foamed before anything gets sprayed.
I learned this trade under an old-school boss who made me tear out and redo anything that wasn't right, and I still work the way he taught me. Anything I flag on the visit gets fixed before the foam goes in, so nothing ends up hidden behind it. I'd rather tell you a job isn't ready yet than spray over a problem.
If the spot is a crawl space where moisture from the ground is the real trouble, open-cell won't fix that alone, and a crawl space vapor barrier usually comes first. People who run shops, offices and metal buildings get the same look-first approach through our commercial insulation work, done in the same order.