A talented musician, songwriter and producer from Detroit, he wrote one of pop music’s greatest songs before his career faded into obscurity.