I can remember a few of these, and thought we'd all get a laugh from sharing. My most, most, MOST horrible one was this:
Working in a 60-bed nursing home, I was caring for a gentleman with terminal cancer. He was having the two-hourly S/C morphine, two hourly pressure care, the whole bit. He had been Cheynne-Stoking off and on for the last 24 hours, and the family was with him as he began to depart this life.
This morning I just knew that today was the day he would die. You just get that when you look at these people sometimes. There were four children, his wife, and several siblings around the bed, and I did my best to care for Stephen and his family, while not intruding too much on this painful moment. Came the time when he was due for he next dose of morphine and pressure care, my colleague and I had an intense discussion. Stephen was so far gone that I was concerned that he would die if we moved him, and I knew his family wanted to be with him for the moment of death. I delayed the pressue care for another hour, waiting for the inevitable. When Stephen was still going slowly, I decided that the need to move his emaciated body could not be put off much longer.
I went to the bed, and explained to the family that Stephen really did need to be rolled onto his other side, and that we would be very quick. They all trooped out, and my colleague and I set to work. First we gave the morphine, then gently placed our arms under Stephen to roll him. He have a loud "Aaa....hhhhhhh.......a." and stopped breathing. Cursing under my breath at the timing, I waited for several minutes to be sure that this wasn't just another episode of Cheynne-Stoking. I even got my stethescope and checked for a heartbeat. Nothing.
Feeling guilty and sad for the family, we settle Stephen onto his back, tidied him, and I went to break the news to the relatives. There was an understandable outpouring of cries and wails as they realised Stephen would never be with them again. They were not angry, just sad that he had finally gone. I stayed with them, and then offered to escort them into the room to say their last goodbyes.
All 8 relatives, weeping, followed me into the room to see Stephen peacefully relaxed on his back. They crowded around, touching him, and I stepped back to give them room, tears in my own eyes as I shared their grief.
To my shock and absolute horror, Stephen took one huge shuddering breath,...then another,...............and another! I stood there in utter shock, as this man 'came back from the dead'. The effect on his relatives was not pretty to watch. They were excited, happy, grieved, shocked, and confused. Again, they were not angry at me (must have been saints!), as I stood there watching. The only thing I could think of to say was "But he WAS dead!"

(I'd verified it myself.)
I waited until the family had settled somewhat, then backed out of the room. I felt about two inches tall, and utterly confused!
I never wanted to look these people in the eye again. First I'd killed their dad, then told them he was dead and upset them all, then he came back to life!!
I cried in the toilet for a while, as you do, then went back to the nurses desk. Several minutes later, all the family silently trooped out of the room and towards the front door. They were calm and collected One detatched from the group and came towards me.
"He's gone now. He died about ten minutes after we went into the room. He just wanted to wait until we were all there before he went. That's why he came back for us all."
I have NEVER experienced embarassment at that level in my life, before or sice!