What wandering I do

What is the deal?
About a year ago I started taking Ambien to sleep
You take the pill and blammo, 15 minutes later you are out. Or so I thought.
Then one day I discovered that I was missing time. I started the movie "Hellboy" and I vaguely remember turning it off. When I turned the DVD player on the next day, it was at the end of the movie. I remember about 10 minutes of the movie. I actually was up and playing with my grandson and watching the movie for a couple of hours after my memory ends.
Since that incident I have been having these sleep "walking" episodes a lot. From what my kids say I guess I am coherent, agile, and able to do complicated tasks like cooking.. all while technically asleep. I don't know if I really am "asleep" but I have only vague memories, if any the next day of what I did. Last night I painted my grandson Kale's room blue.
I remember the beginning of the process like taping up the doors and the floors, but I woke up without a spot of blue on me… so either I bathed or I am a better painter when I am asleep than when I am awake.
I have painted 4 rooms in my home, sewed up a bunch of pant hems for my grandson, cooked, cleaned, done laundry, had several dozen conversations with various people, even put the trash out on the curb.
The one activity I find most bizarre is that I cook when I am unaware I am doing it. One day I woke up to a wonderful smell and discovered I had cooked a whole turkey dinner the night before. I have since made corned beef in the crock pot and a couple different roasts (all of which I do not remember doing).
I seem to have no ill effects from all this night time adventuring and I stay in the house, so who can say why I am doing it and if it is bad or good?
I only know I wish I had this when my kids were growing up. My house is easier to clean when I don't know I'm doing it.