I liked "Jeremy" by Pearl Jam, about a boy who shoots himself in class.
And the early Black Crowes albums were excellent, especially "Shake Your Moneymaker". But I'm stumped trying to remember any other decent songs ...