There are so many tales of artists lost too young, but way too many of them are more cautionary tales of self-destruction and failing to heed the constant