Anchorage, by Marian Call. Also, Good Old Girl, by the same artist.
These others may be too old, but I like them:
It was old even then, but a song I liked when I was in the psych ward and that I've turned to in difficult times since is A Diamond in My Crown, by Emmylou Harris. It's a very plain song, with very simple accompaniment. If you are from a Christian background, you will probably interpret it as a religious song (as she probably meant it); if you are not (and I am not), you will probably interpret it as secular. Either way, it's a song about enduring and triumphing.
Love, Look Away from Flower Drum Song, especially the Lea Salonga version from the 2002 revival.
If Only, from Whistle Down the Wind (music by Andrew Lloyd Webber (Cats and Phantom of the Opera), lyrics by Jim Steinman (Bat out of Hell)).
The Mary Ellen Carter (Stan Rogers) makes me cry, but it actually has a very positive ending that might help you.
I Think It's Going to Rain Today, especially as recorded by Bette Midler.
Also, this is not really a song, but look up "Fawkes the Phoenix," from the score of the second Harry Potter movie. Legend has it that the song of the phoenix brings hope to good people -- and John Williams, the great American movie composer, actually wrote the phoenix song so that it does that.
Finally, The Ashgrove, as recorded by Roger Whittaker, is about summoning the friends of the past in memory and being unable to look to the future. It's 200 years old, but songs that we still sing after 200 years are still around for a reason.