The singer-songwriter from Detroit, Mich., finally found fame in the U.S. four decades after his early recordings were released