Is there any glory in a rock and roll death?

Is there any glory in a rock and roll death? We tend to glorify rock stars that die young as if their deaths were the crowning achievement of their lives. Their deaths colour their music with romantic notions of living fast and dying young, of stars that burnt to brightly.
We don’t think about the details. Keith Moon, had before he died, grown fat, pale and sweaty as his body could not cope with the alcohol and drugs he was taking. John Bonhom choked on his own vomit in a motel room. Kurt Cobain shot himself in the face and was not found for days.
If any of these deaths happened to an accountant or a construction worker or anyone else they would only inspire sympathy or maybe even distaste. Yet we glorify them.
Is it time to put this myth to bed?