He was one of New York rock's most exciting performers, leading a band that played with Nirvana. Inside his rise, flameout and tragic end