I noticed the Grim Reaper hung around a bit after one of my sims died, so I did an age transition on him… He ended up this weird, solid black person with a duck floaty. Then he went and sat at the kitchen table before disappearing into a puff of black smoke. Another Sim of mine died and he was still like this.