A 70-year-old man with metastatic pancreatic cancer in the last days of life becomes increasingly agitated, trying to climb out of bed and pulling at lines. He has no reversible causes such as urinary retention or pain. Non-drug measures have failed. What is the most appropriate pharmacological management of his terminal agitation in a hospice setting?