Sleep walking usually isn't that scary. Since you can move and all, your brain isn't jumping the gun right to "DANGER OMG EVIL GONNA GET ME" mode. I've sleepwalked (while sleep talking) a few times, and I don't remember it ever being scary. If you wake up during it, you can feel pretty dang disoriented, though.