Perhaps the best front man of the 1990s dies in Detroit