Ghosts?

The last ghost I ever played with in my game was Johnny Zest. He married the sim I was playing, they finally got married on Christmas Day and also the same day he died on. He was just to darn happy; new wife, new toddler, and the holidays were just too much. A short time later his ghost called up his widow and asked her out on a date. I was thinking great, maybe I can get a playable ghost to add back into the family, and work on resurrecting him. But the problem happened when he decided to carry on romantically with another woman. My sim at the time was a vampire, and she witnessed the betrayal, and after that, it was a real mess, because she was attacking everyone around her. I was just glad her child was still a toddler, which kept him safe from her rage. After that, I just sent Johnny off to the great beyond to never be heard from again, well that was until I started a new game save.