I personally find it pretty chilling to see social media profiles of the deceased; around 5 years ago one of the students in my program at EMU was shot to death by her own mom a month before she graduated; aside from the shock of the seemingly out of nowhere murder, it was beyond weird to see her profile as it was before the incident, basically up to the minute before she was shot. The profile on Facebook is gone now, but it still gives me chills to see her activity mixed with touching memorial messages people posted on her wall.
I don't think there's a good, clean way for social media companies to deal with the dead and their accounts.