Following Nick's link to the Trivia section of the Cyberhymnal, I stumbled onto this Psalm 43 (42) based hymn text by none other than the Sixth President of the United States, John Quincy Adams:
Send forth, O God, Thy light and truth,
And let them lead me still,
Undaunted, in the paths of right,
Up to Thy holy hill.
Then to Thy altar will I spring,
And in my God rejoice;
And praise shall tune the trembling string,
And gratitude my voice.
O why, my soul, art thou cast down?
Within me why distressed?
Thy hopes the God of grace shall crown;
He yet shall make thee blessed.
To Him, my never failing Friend,
I bow, and kiss the rod;
To Him shall thanks and praise ascend,
My Savior and my God.
This COULD be good material STILL for a Catholic hymnal - far better for an Entrance hymn than Here I Am, Lord or Gather Us In or even All Are Welcome. Best choice of course would be the Introit of the day, but if you MUST use a hymn (many of us musicians I'm sure still feel like we're in that situation at this point after forty years of damage), this is ideal.
Suggested tunes: FOREST GREEN, ELLACOMBE, KINGSFOLD, HALIFAX
(or, split the two verses into four short verses and use NEW BRITAIN, ST. ANNE, DUNDEE, ST. STEPHEN)
President Adams wrote a few hymn texts, but this one really caught my eye.