Before you decide on spray foam or another method of insulation, it's important to understand the superiority of spray foam compared to traditional materials. When compared to fiberglass batts, spray foam offers nearly double the R-value per inch, achieves air-sealing and insulation in one step, won't be damaged by mold or moisture, and won't settle, compress, or otherwise be damaged to the point it needs replacement.
Spray Foam Polyurethane
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! :)