Are you sure about this? I think this was a work by Haendel, not Beethoven.
Is I Vow to Thee a hymn? It gets played at a lot of state funerals…
This one is also gorgeous: https://www.youtube.com/watch?v=MbhxZOOXLvU
Some excellent suggestions here. I’ll add:
Christ triumphant, ever reigning to the magnificent tune “Guiting Power” sic
Lift high the Cross, to another magnificent tune “Crucifer” (and it’s probably no coincidence that I’ve picked two that have a sort of organ “fanfare” punctuating the tune)
I have a soft spot for Hail, gladdening Light which is sung with a psalm-like recitative. Haven’t sung it in forty years, though…
I have some favorites that are more or less tied to the church calendar. They are made more dear by the fact that we only sing them once a year:
O How a Rose E’er Blooming (Christmas)
Go Tell It On the Mountain (Christmas)
Brightest and Best of the Stars of the Morning (Epiphany)
Drop, Drop Slow Tears (Lent / Holy Week)
Were You There (Lent / Holy Week)
Hail Thee, Festival Day (various depending on the Festival)
The Church’s One Foundation (usually Pentecost)
For All the Saints (All Saint’s Day)
I Sing a Song of the Saints of God (All Saint’s Day)
Holy God We Praise Thy Name
Ave Maria
Be Thou My Vision
Lord of all Hopefulness
Alleluia, Alleluia Let the Holy Anthem Rise
Tantum Ergo
O Salutaris
O Sanctissima
Panis Angelicus
Bring Flowers of the Rarest
Hail Holy Queen
Also Catholic, but not a 70s or 80s kid.
Picture it – middle of the night in the hospital. Mom turns to Pop: Am I dying? Yes, I’m afraid so. OK, then here are the songs I would like at my funeral. 
How Great Thou Art was one, and also In Paradisum as a solo by the cantor and I believe Let All Mortal Flesh Keep Silence.
Grr. Maybe it’s a cliché but I expect Immaculate Mary processional and Hail Holy Queen recessional at Mary feasts. Nah, our current organist feels she must buck tradition and do unfamiliar and meh stuff like “No Wind At The Window”.
Cradle Episcopalian here. Too many favorite hymns to mention, but one that springs to mind at once is “Crown Him With Many Crowns.”
http://www.hymnsite.com/lyrics/umh327.shtAmen, brother.
And of course, there’s always In the Garden of Eden by I. Ron Butterfly…
It is Well With my Soul
How Great Thou Art
His Eye is on the Sparrow
Softly and Tenderly
In the Garden
All my Trials
I love that Alan Jackson “Precious Memories” CD. I don’t go to church much anymore, but it was a huge part of my upbringing. When I listen to the old hymns sometimes I can hear my grandmother singing along in my mind.
O Come, All Ye Faithful in Latin (Adeste Fideles).
Hee! I always considered this a children’s hymn, but once in (adult) choir we were called to sing it in a regular service. We had to rehearse it downstairs and were sternly told to get all the laughter out of our system beforehand, so we could do it in church with a straight face:
(with the proper British double-sounded “t”, of course)
This is properly known as “Bump for all the saints” because of its start on the off-beat: (under the breath: “2 - 3 - 4 - Bump) FOR ALL THE SAINTS…”
Excellent.
I always hear the “Brady Bunch” theme during that one.
“Here I am, Lord.
Is it I, Lord?
Who was busy with three boys of his own…”
Seconded. What heartbreaking beauty.
I really like this version.
And this version of O Come,
Hah! I’ve never thought of that but now I won’t be able to get it out of my head.
I’m a confirmed agnostic, but I sing in a choir that does a lot of sacred music. Two of my favorite recent-ish (20th century) compositions:
A Prayer for the Middle Ages by Howard Hanson. It’s a medieval sacred text set to music for a capella choir. It starts out a bit atonal and modern sounding, and then transitions partway through into just glorious pure chords. A lovely piece.
Franz Biebl’s Ave Maria (Angelus Domini), popularized by Chanticleer. One of the few things we’ve performed which has brought the audience to mass tears.
And a wonderful (and not too weird) modern arrangement of Amazing Grace by Eric Esenvalds.
Somehow I can’t find it, but our current organist regularly plays something like “Moved By the Spirit, Let Us Move” or some such, which references praising God through art and dance, etc. When it gets to the part about mimes, I :rolleyes: and put the hymnal down.