It seems little pointless to say he's not a good person, as you say he probably had substance abuse problems himself.
Scott also chose to do drugs with somebody who had substance abuse problems, additionally Scott was a big star, leader of the band, and Tommy's boss. So by the same token, what does that say about Scott?
They were just 2 people making bad decisions, and sadly for one it worked out a lot lot worse.