What kind of healing can I realistically expect from the manifold graces of the anointing of the sick?

The answer that came to me in prayer is “liberation”—freedom from the domination of pain and infirmity. The greatest temptation that sick people have is to give in to hopelessness and despair. Self-absorption is a consequence of intense pain and suffering. The danger is that we will think only of ourselves, of our suffering and our aloneness. For many of us who are ill, healing includes “letting go” of our preoccupation with self and “giving back to the Lord” the depression and discomfort that are the consequences of our illnesses—whatever they happen to be.

From Surprised by Grace: Memories and Reflections on Twenty-Five Years of Episcopal Ministry, Chapter 4, “Liberation” by Archbishop Daniel M. Buechlein, OSB who returned to the Lord on January 28, 2018 following a long illness.