The most erotic moment in a snuff story is the moment of realization, when the sub finally recognizes that she is not going to make it out alive. Especially if she gets one last, final orgasm. The moment of death, after that, is almost inconsequential.
An interesting conjecture Nikka, bearing in mind your signature line, but I think I understand what you mean.