Lyric discussion by Cam-win 

Cover art for Tender Sugar lyrics by Mary Elizabeth Mcglynn

In regards to Silent Hill, it looks like the viewpoint alternates between Walter Sullivan and Joseph Schreiber (the dude who was in the apartment before Henry).

Also appears to be about cocaine, though.