In reply to mwr72:
AAAAAh I wrote most of a reply, that was quite long, and then stupidly clicked on your profile to check where you are based, and when you click "back" the draft is gone.
In short, I was suggesting non destructive testing (radiography, ultrasonics, boroscopes, eddy current, remote visual). Pipe welds, castings, aero parts, automotive components. Wide industry, technology-based so interesting, should not be any heavy lifting, and a good employer will give you room to learn on the job. You are in a part of the country that is good for this sort of thing e.g. Rolls Royce at Rotherham or Barnoldswick, or Exova in Sheffield.