My favourites are four amazing songs that are religious in the broader sense:

'When We Become' by Clem Snide
'Sand and Water' by Beth Nielsen Chapman
'Let the Mystery Be' by Iris De Ment
'Small Voice Calling' by Ralph McTell


Also a humorous take on all this:
'Night Rider's Lament' ('Why Do You Ride for Your Money?') as sung by Nanci Griffith.