Cemetery Lot Trait
Designate a lot as a cemetery and your Sims can remember those who have passed.
I set my lot as Generic. Sims can visit and will get a small Sadness buff while they are at the Cemetery, but it doesn't last long.
While there, in the Stories section of the interaction menu, they can share stories about Sims who have passed.
Occasionally, spirits may visit around midnight, but it won't be "spooky" unless you add the spooky trait.
The minimum comment length is 10 characters.