Yes, this has been my experience with a family friend who died of a brain tumor. Basically, once you're in hospice (in this case it was home hospice) and it's clear you're going to die, they just hook you up to the morphine drip that you can press yourself.
Obviously for many people it's still very scary - it is death after all. But the self-administered morphine drip has been around for ages and is relatively uncontroversial.