The soul singer co-wrote one of the most poignant love songs ever recorded, and enjoyed numerous hits with the Drifters and as a solo artist