I think Buffy is an example of a show where death works quite well, because the vast majority of characters are significantly changed if they do return from the dead - either as vampires, ghosts, in dreams or as manifestations of The First, does not diminish their deaths as either their physical body is gone or their soul is and they have not defied death.