The insulation at eaves level will leave your loft area comfortable for use and free from condensation. By installing the insulation at rafter level, it keeps the loft void warmer and prevents condensation build-up, which can otherwise occur when increasing insulation at ceiling level. The warmer, drier, cleaner roof space eliminates the risk of pipes and tanks freezing.
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! :)
I recently did a remodel project for my basement using spray foam insulation. The original builder has used fiberglass, but I wanted the best insulation i could find. We chose closed cell foam because it blocks moisture from getting into the house. It took one day to install and was fumey for about 3 hours. It was pretty cool watching it being done. It comes out as a liquid and then expands rapidly into a foam. It's quick! Then they took a types of saw to shave it flat with the wall studs so we could then go ahead and drywall.

Roof Coating Denver Colorado