Honestly, Paranormal doesn't add much to the ghost (after)life state. The only new thing is a couple of special ghost NPCs and a chance for all regular ghosts to be summoned via the séance table. If there are no ghosts in game you'll summon a spectre instead, whereas having ghosts in the save will give the chance to summon either.
Dream Home Decorator is fun if you like interior design. I recommend giving all the sims in your game some preferences (décor style, colours and a hobby or two) so that you have a variety of things to work with. If you don't then they they assigned randomly and aren't as varied or fitting. Avoid the level addition gigs as they are very buggy. Some other gigs are bugged so you have to work around the bugs and fix lots later. You can gain fame via the career by publishing your before/after photos and articles etc.