For the first time, the final years of one of the world's most captivating rock showmen are laid bare.