Britain has been declared the best country to die in - yet hospital horror stories are still rife. Lena Corner talks to those who care for the dying and those left behind and discovers what the gentle ethos of hospice care can teach the NHS