What's the Life of a Man. May not seem very optimistic to many people, but the sentiment chimes in with my beliefs, and I once gave it to a woman with terminal cancer who felt very comforted by it.
I could think of loads of others, some that have been mentioned, others too many to be listed. I find most songs uplifting in some way. Great thread! - Susanne