I think most of the time ghosts should be the negative unhappy-thought-makers they presently are.
Unless the dwarf had strong ties to the world, yes.
If vampires start actively recruiting, for instance, and one of the new vampires has a dead parent interred in the fort, their parent's ghost might start haunting the place again until they're killed. If you break off from your civilisation and get attacked by dwarves for whatever reason, a loyal dwarf or two buried before the split might rise up, in addition to other dwarves leaving in outrage before the attack.
Hm, I hadn't thought about that...
But outside of that IMO dwarves should only return from their rest for something relatively big, not because their tomb isn't fancy or somebody messed up their engraving.
Well, depends on "not fancy." An unmarked casket tossed in an abandoned mine? Barely better than being left to rot in the caverns.