From the Gospel journeys of Aretha Franklin to the late-life monasticism of Leonard Cohen, the great musical artists of the 20th century were often quasi-religious figures