Hi Coolpeach,
I have never worked hospice, however I watched both of my parents die from cancer. My father died in a hospital when I was 10. My mother died in a hospice facility 8 years ago. I have also worked in ICU.
I think the best place to die is somewhere that makes sure your pain is managed and that encourages your family to be as involved as you, and they, want to be. Sometimes that can happen in the hospital. It just depends on the nurses

.
When my father died in 1977, my access to him was restricted because of my age. I was allowed 15 minutes a day with him until the last week of his life. At that point someone decided he was too sick and I wasn't allowed to visit him any more. I didn't get to say good bye or tell him one last time that I loved him.
When my mother died in 1999, she was in a hospice. The experience was very different. The energy was different. It felt like you were walking into a giant hug. It was also very comforting to have people around who specialized in end of life issues. My mother had a much more peaceful and pain free death than my father.
When I was working in ICU, I had a 55 year old patient who was a DNR. He was approaching his celestial transfer on my shift. His wife had been sitting in the chair next to the bed all day. People had come and gone and at around 0200 she asked me if she could put down the side rail because it was hard for her to hold his hand with the rail up. I said sure, not a problem.
I told her that if she would like, I could reposition her husband in the bed and she could get in the bed and snuggle with him. She took me up on my offer. I pointed the video camera in the room at the ceiling (for privacy), repositioned her husband, got her comfortable in the bed with him, pulled the curtain and left. He died in his wife's arms at 0337. As she was leaving she thanked me for allowing her to have one last cuddle.
I guess in my mind, it isn't so much the place, as it is the people who are caring for you. I don't care where I die. I just hope that it is sudden and that there isn't a lot of pain.
Nursing News