I don't know if this counts. I had a stroke while I was sleeping. I had very vivid nightmares that night, almost the worst nightmares I've ever had. It's made me terrified of dying in my sleep. If my final experiences are going to be like that I absolutely do not want to go out in my sleep.

"He died peacefully his sleep" is something people only say for catharsis.