Scott's memoir Sinner's Creed, unleashes behind the scene realities about his suicide attempts, alcohol-induced rampages and intimate details about his abusive childhood