I've never had a Magsafe power adapter that's suffered any problems. I've been using portable magsafe equipped Macs for 10 years.
Because WD-40 acts as an electrical insulator when it drys and is highly flammable when it is in aerosol. Not really something I'd watt to spray on an electrical connection...![]()
The mistake I see all the time is that people wrap the cord too tightly.
First, Apple has a decent advice guide here on how to avoid damaging it: https://support.apple.com/en-us/HT201600
Second, most people put too much strain on the cord when they wrap it around the flaps. You should leave a little loop at the beginning like in the picture below.
![]()