What about Suicide Is Painless from the movie "MASH?"

Richard Cory and A Most Peculiar Man, both by Simon and Garfunkel.

There's a list of thirty classic rock songs about mental illness .