When TS3 first came out, I didn't know sims could die (I did not play TS1 or 2) until my insane sim with no handiness skill whatsoever decided to tinker with the stereo. After she was electrocuted the first time, she decided to give it another go, so I let her. When this killed her, I didn't know what to do with the remains, so I left them on the dining room table. Every other night she would show up, and was in the portrait panel as a controllable sim until she went back to the urn in the morning. I finally figured out that I should take the remains to the cemetery, then another sim in the house got the science opportunity, brought her back as a playable ghost then fed her ambrosia to bring her back to life, and she's still part of the household today.
I have built some catacombs on the family's home lot, and the ghosts I get now don't show up as controllable, so I just assumed this was fixed in a patch.
"The ice is near, the solitude is terrible."