You know, this was something I had never thought of. In my nursing career, I've not had to deal with death at the moment it occurs. (I've worked drug rehab and OB) I always read the obits, and occasionally see the name of a former resident at the rehab, or a little angel that didn't make it out of the NICU, but that's about as close as I come.
Hubby and I recently attended his grandfather's funeral. There were alot of people there we didn't recognize, and upon asking, we found out that most of them had been his nurses through out his lengthy illness and hospitalizations. I was so touched by this. I would imagine it would provide you with a sense of closure, and I'm sure it would touch the hearts of the loved ones.
I would say that there are going to be nurses that are resistant to this, some nurses just like to leave work at work. To each their own I guess. I just hope you don't let someone talk you out of doing something that brings you peace