Paul McCartney might have a golden halo around him in many people's eyes, but not everything could stand the test of time in his catalogue.