People are already forced every day to endure horrific and traumatic deaths worse than anything anyone would ever, ever allow for an animal. It's not new, it only seems new if you've previously been shielded from it and believed "keep them comfortable" is anything more than a euphemism for discontinuing active treatment. There is no comfort, only trauma.
Ask for sedation. Don't expect anybody to bloody bother offering it unless your pain and distress has reached the point of being too inconvenient for them to ignore (and they're so disconnected they can ignore a LOT of suffering - even screaming in pain can and will be ignored). Otherwise you will be left to suffer.
My loved one's death was barbaric and traumatic, and that was with supposedly good palliative "care". Ask for sedation, ask for pain relief, and don't stop asking until it's been provided.