First off, great topic MC.
I find a lot of the songs mentioned walk a fine line between being "observational" about the human condition versus being philosophical about it, although sometimes both will happen within the same song. Both perspectives are probably valid; so, here's a couple of more observational songs:
Think For a Minute - Housemartins
Don't Interrupt the Sorrow - Joni Mitchell