History has judged STP pretty harshly. These days, they're kind of regarded as a poor man's Pearl Jam. Probably because unlike most of their grunge peers, they weren't from Seattle, and therefore weren't deemed "authentic". But to me, those first two albums are stone cold classics. "Purple" is probably one of my top 5 albums of the 90's. I wore it out back in the day. Not a bad song from start to finish.
But yeah, the only surprise in today's news is that Scott lived THIS long. Heroin is a hell of a drug.