Keep my garage moisture free

Learned a little about the spray foam insulations. So theres a couple types of spray foam options. Closed cell, for walls and open cell, for underside of roofing.
I was told the open cell allowed water to permeate and drip, IF a roof developed a leak. If the water wasn't allowed to leach through at the roof area, you may never know or find a leak...it could potentially migrate down to a lower wall area, undetected.
Plus the closed cell is a more expensive chemical process, so I was told.
So you went with open cell all the way around? That’s interesting, I didn’t know that about the foam