Serious question.. I'd have thought it not practical to remove the cap on the wall (and that's assuming you can access it from the attic).
edit: "top plate" is the term I couldn't remember. substitute for cap in my comment.
We got blown insulation in the floors (ie between roof and floor), he drilled a 2 inch hole every two feet or so. We added our parquet floor right on top, with just some thin XPS sheets inbetween for noise.
Not sure about drywall, but I'd imagine it's similar. Easiest would be to just put some 6mm plasterboards on top to cover the holes, saves you handling each one individually.
A cheaper option is rigid foam with canned spray foam around the perimeter.
That's certainly a way to retrofit an older building, but you still need a heat pump.
A heat pump isn’t cost effective compared to Reno with spray foam. An average heat pump probably takes a decade minimum to pay off.