There are some ghosts in the generic NPC thread. If you set it to print and search for Spirit Form, you can find them easily enough.
There's a Spirit Form rework on the wiki, but I'm not sure if it's any good.
If basic ghosts feel weak, why not have the ghosts be of people who would've been serious threats in life? A wizard ghost can probably still fireball you.