There is extensive research and clinical practice on the topic of comfort-measure care at the end of life. Opioids are, indeed, often felt to be helpful at the very end.