I'm about to have exactly that experience with my mum's house . . .The company that did spray foam in my dads house swore it would seal the old tiles, stop them leaking, stop them blowing off, and gave a 30 years guarantee.... except after he died and we came to sell the house the company didn't exist any more....
We had to get a roof specialist to come in and say there was nothing wrong with the foam etc, before the sale could proceed.
As well as the PVC over-cladding on the timber front and back, soffits etc - which I reckon has probably guided 30 yrs of moisture inside . . .