I really like that you suggested not only fear as an emotion to seeing a ghost. It's why I usually don't support changes when people talk about them. I'd really like to have a reaction that was happy or inspired or anything like that. I tried to tell a story around the time they added tension in. It was about a little boy whose parent's had died and he still lived at home with them. I had to make him in CAS. Either way I was disappointed that he often got tense there. I wanted the story to be basically about this loving family that still cared for him but it didn't get off the ground because of the reactions he was having.
I'd love this maybe to be a trait even or at least having some way to pick what emotion a sim should have. The default could be fear or tension.. I just want a possibility for other emotions (maybe even neutral.. like they are regular folks to your sim).
I wouldn't mind the either good or vengeful .. but I'd also like something more in the middle maybe? I'd have to think on that. I'd love to have a vengeful ghost though :).
With what you suggested though if I had made them "good" ghosts it would have worked.