“I was walking down the street and I saw this junkie washing out his needle with wine.” How one of the most hyped metal bands of the 90s bounced back from firings, studio disasters and, erm, constipation