The musician, who won several Grammys and also collaborated with the Rolling Stones, Stevie Wonder, Paul Simon, and others, had been battling prostate cancer