Wow, I guess unpopular opinion: I love killing my sims and watching others kill theirs. But only in certain saves. In my Black Widow save, she has about 50 urns in her basement. (The ghosts... Oh the ghosts... Everything breaks) In my "Pull random sims from the gallery and watch them do crazy things together" save, I enjoy trapping and drowning the npcs just to get them out of the world. And in some of my other saves, I will kill a sim who just pisses me off, especially since I got Get Famous, I will trap and starve sims that just walk in uninvited. On youtube, I definitely enjoy watching certain gamers make their sims absolutely miserable, but mostly for scientific purposes, like how much does it really take to kill a sim in a certain way.
Now on the other hand, I don't kill legacy sims. Once I get 6 grandparents, I put them in a retirement home together with a young adult nurse and turn auto age on and just play them until they die. Once it gets to about two days left of their lifespan, I invite their kids and grandkids over and lock them all in this giant room I call the death bed room. It only has chairs and a bed. The family is forced to talk to each other or twiddle with their phones while the grandparents pass surrounded by their loved ones. It's sweet. After all the grandparents in the retirement home die, the nurse goes around and puts the urns on the family lots and then I play each of the families and they mourn and then put the urns on a graveyard lot.