Do you think attic air sealing, or more effective attic insulation would have a big impact? It does feel like the roof turns into a radiant heater in the summer.
(The only energy auditor available in the area is also in the business of providing the insulation, which is why I’m skeptical.)
If you have a really old house make sure you don't have vermiculite insulation which might make things way more expensive cause it likely has asbestos in it. Apart from that you can also DIY it but it's messy. Your state may offer incentives for doing it too.
https://www.energystar.gov/campaign/seal_insulate/attic_air_...
You'll still want insulation on the floor of the attic space, and seal off the living space from the attic.
From what I gather the main complication is keeping critters out while opening your attic to a substantial flow of fresh air. A pile of rockwool insulation sounds like a hell of a home for many small mammals, and bees can get past all but the finest of screen meshes. It seems feasible to diligently install screens on all the vents but it'll be a maintenance burden to keep them intact as the years go by.
I heat to 18oC in winter (Montreal) and AC to 24oC in summer. My electricity bill averages USD$40 per month. The windows made a nice difference, and still seem efficient after 10 years.
But most energy losses in older buildings are from leaking air not thermal conductance. So upgrading to R-1 but sealed and we'll installed Windows can do a lot without having to spend 50k.
Also, you can use thermal shutters that have MUCH higher R-value than even top of the line windows.