The brooding singer-songwriter tried to humanize society’s darkest wishes, and lamented its inability to ever be at peace