From Madonna to Martin Scorsese, Paul Elie makes the case for spirituality's influence on American musicians, writers and artists in the decade of materialism