As long as they're kept in moderation, I like ghosts. I only like having a few around, so every once in awhile I'll go into Manage Households and delete most of the ghosts that have been generated. I noticed Spooky Day really generates townie ghosts, so that's usually when I round up the loose ghosts and delete them out.
I have a graveyard in my game, so ghosts mostly hang out there. It's nice because they don't break your stuff, and gives me a reason for my sims to "put them to rest". I had an only-child sim have a ghost friend during Spooky Day, which fit nicely into the story I made for her. I'll tend to keep Family-Oriented sims around longer as ghosts...they're making sure everyone is going to do well before they pass on fully.