I've only added one ghost to a household. It was my Sim First Artist's boyfriend in the Time Lord Challenge. He accidentally died from overexertion after woo hoo with Second Artist when he was an elder before I knew that was a thing. He's Third Artist's companion now. I only keep ghosts around if the challenge I'm playing doesn't allow for releasing their spirit or moving them somewhere else.
Most ghosts otherwise get to stay around if they're helpful instead of mischievous. Once they start breaking stuff? Out they go to the deep forest. Some I've had taken to a cemetery I downloaded, and one 'lives' in Sylvan Glades by request. Her husband visits sometimes, but not as much now that he has a new love interest. It's too hard for him because he feels guilty, like he's cheating on both of them somehow. If that makes sense? He loved his wife very much, but needs to move on.
My Sims rarely go out to bars, so they've only been there for Ghost night a couple times. Any ghosts that get generated for that, or from campfire stories, I remove using manage households. I don't want a bunch of ghosts wandering around willy nilly in my game acting like they're still alive. It annoys me so much too when ghosts call my Sims about anything. They're supposed to be dead, how do they even have a phone? lol It's especially weird when they call to convey their condolences for losing a loved one and they're calling about themselves! o.O
Personally, I wish ghosts were more like they were in TS2. They seemed more like 'real' ghosts that could scare the bejeezus out of Sims, make them wet themselves or even die. Oh well, to each their own. I don't hate the ghosts, I just wish they were a bit more like, well, ghosts! lol