I don't believe that I have ever had a socket that could not be repaired. I do the following to all my sockets on the playfield:
1. Clean with dremel brush
2. Solder barrel to base
3. Remove wire from tab and solder it to the "tit"
If it is still flakey, I give the barrel a light squeeze.
Never fails.