They don't make people sleepwalk so much as just turns their short term memory off. So you get people taking zopiclone before bed and then they stay up talking to the ambien walrus all night.
This actually happened to me once. Dead serious. Can't believe I remember it either. But anyways...
I had just taken 60ish milligrams of Zolpidem, and decided to take a shower and go to bed. Well, like any other time before I take a shower, I decided to fap in the shower. As time went on - and the Ambien started taking effect - I noticed that things started getting strange (like they always do on Ambien). All of a sudden, out of nowhere, I hear the voice of a little girl. I turn my head and clear as day - in the fog on my shower bathroom was the face of a crying little girl.
I immediately got up and asked her what was wrong and if she needed help. She didn't reply to me, she just kept crying. I stayed in my bathroom for around 5 hours trying to comfort this little girl as best as I could. But she just kept crying and crying. Eventually - I came to my senses and realized that she wasn't real. Which actually made my feel relieved because I had no idea what was going on, and I thought that my fogged up mirror was a glass window or something and that she was trapped inside the other side of my mirror.
I came pretty close to breaking the mirror in-order to free the little girl - but luckly for me, I realized that it was just the Ambien walrus and after I realized that, I got out of the shower, took more ambien and...
I don't remember the rest tbh.