With honesty rarely seen among celebrities, Demi Lovato chronicled her mental illness, addiction, recovery and relapse through music