Greg
Do some research on the actual sound deadening qualities of spray foam. Several years ago I had a job we needed to increase the STC rating of. I asked my insulation guy if he would spray the interior walls after we did one side of the drywall, he wouldn't because spray foam isn't as good at deadening sound as bat insulation.
I would say the open cell is going to be better at sound deadening than closed cell, however what worries do you need to have with Vapor transmittance down there? Closed cell is a vapor impermeable product (I really like spray foam FYI) so we use it in exterior walls now all the time. We're having to hit R-35+ in the walls up here now with all the new large window design styles so we spray 5"+ of closed cell all the time with R-60+ ceilings.
If you want max sound quality with good insulation you may need to look into bat insulation, then install a sleeper system at 90 degrees from the studs to hang the drywall on. Remember noise travels through direct contact, every time you reduce the contact area of a product, and introduce dead air space you reduce noise. Or if you want Max R-value and ok sound spray it with closed cell, then if you want to have some added quiet zones you could look at some specific type sound deadening blankets that you hang on walls or even create an enclosure with. We use those at work in a 3'X5' version all the time.