“The White Knight of Soul” penned songs like “Last Kiss,” a hit for J. Frank Wilson and the Cavaliers and Pearl Jam, and “Goin’ Back to Miami”