WD-40 is not the answer. It displaces moisture (the primary/original purpose of the product) but does not provide a lasting protection. I hesitate to recommend a specific product here, but I can relay some that may lead you in a useful direction.
Dielectric grease is often used around and inside electrical connectors that need protection from water and corrosion. Often applied at the factory to automotive and marine electrical connectors. The type I typically use is a clear gel form, but I think it also exists in liquid and/or aerosol forms.
In regions where salt is applied to winter roads, spraying the undersides and metal cavities of cars with a protective oily spray is common practice. Two brand names that are common in my area are Rust Ceck and Krown. Both products normally applied at automotive shops, but aerosol spray cans are also sold for consumer use. I have applied Rust Check spray to many things, from door lock cylinders to the bolts on outside equipment.
In general these anti-rust products are also safe to use in and on electrical connections. On rare occasions the oil has reacted with the plastic wire insulation, causing it to soften or swell. Depends on the particular insulation material involved. The oil does not conduct electricity, but it does creep across surfaces (as part of its anti-rust properties) so whatever you apply it to will be oily to the touch. Frequent wiping off of the outside surfaces eventually minimizes the mess.
I imagine the spring cavity inside the MagSafe connector is tiny, so a fraction of a droplet of protectant would probably be enough to soak the tiny steel springs and protect them. Whether you can effectively do so without creating a messy connector during future use I could not say.
If indeed you can convince Apple to replace several or all of your failed power adapters with new might be the most effective 'fix'.
There was a time when third party companies (well,
at least one ) would sell repaired and refurbished Apple power adapters. I bought at least one which came with a brand new connector. Indeed, their web site showed examples of frayed cable ends and damaged connectors. This tells me they had access to replacement connectors. I don't know which companies still sell refurbished 'genuine Apple' power adapters. Lots of knock-off Apple fake products around.
A quick Google search turned up images of
MagSafe connectors with attached cables (sans power supply).