She was known as the high priestess of soul, but the late American musician, adored for hits such as My Baby Just Cares For Me, was a hugely troubled figure.