Here are some prayers that I (Louise) have found helpful during my work in hospitals and hospices:
God of the present moment,
God who in Jesus stills the storm, and soothes the frantic heart;
bring hope and courage to N. as s/he waits in uncertainty.
Bring hope that you will make her/him the equal of whatever lies ahead.
Bring her/him the courage to endure what cannot be avoided,
for your will is health and wholeness;
you are God, and we need you.
from the New Zealand Prayer Book
Grant, O Lord, to all those who are bearing pain
your spirit of peace and hope
of courage and endurance,
cast out from them the spirit of anxiety and fear;
grant them perfect confidence and trust in thee,
that in your light they may see light;
through Jesus Christ our Lord.
Lord Jesus, when you walked among hurt and suffering people, you looked at them with understanding, and approached them with arms outstretched, showing them that they were truly loved. Come now, and touch all those who are in pain and distress (especially N and all who love her/him), and comfort them with your love. Pour into their hearts the gentle balm of your Spirit. Amen.
Jesus our Healer, we commend N into your gentle hands. Ease her/his pain, and heal her/him in body, mind and spirit. Be present to her/him through the support of others, and in the care of doctors and nurses, and fill N with the warmth of your love, now and always. Amen.
A prayer for those who are dangerously ill:
Heavenly Father, we pray for those whose life on earth hangs by a thread,
Especially for this your beloved child N;
May s/he be filled with your peace, and surrender her/himself totally into your hands,
Knowing that you have loved her/him with an everlasting love. Amen.