spray foam insulation...is it worth it?

What kind of electrical wiring is in this house? Is it new or at least post 1950 or so? A house this old may still have knob and tube wiring and you can’t insulate that because it needs to dissipate heat. It probably has been upgraded because it is hard to get a mortgage or insurance on a house with K&N, but it still does exist. Do not blow insulation into walls that have knob and tube.

Another question to ask, is this house in a historical zone or registry? A house built that long ago might be and there are limits to your options for upgrading or remodeling a historically registered home.