Steve: If your spray foam installer leaves the vents open, he will be committing the 2nd of the 4 problems I described above. You will most likely have comfort and efficiency problems. You may well have condensation problems. You will be spending a lot of money on a product that likely won't perform as it should. Don't let him leave the vents open. If the installer you've chosen doesn't understand this, you may want to choose someone else.
My other question was gonna be this. We ripped all the drywall out after Hurricane Harvey and we found some latent termite damage from some time back. One of the common studs in one corner is pretty well eaten to shreds. I was gonna brace it but then I read about more modern framing practices and I read how each stud is a thermal bridge. So now I'm thinking that I won't bother with it because the house hasn't fallen down and the foam might help a little. Unless you say to brace the stud. Then I'll do it, Martin! :)