@slkanowitz Have you contacted a hospice organization? Contrary to what some believe, anyone with a life-threatening diagnosis can qualify, and some people receive services for a couple of years.
They specialize in helping manage your pain and provide a lot of comfort care and supportive services - in your home, or in a care facility if that is where you reside.
Do you have anyone assisting you?