If he was actually sleep walking this is whatever. The kids didn’t open the door they just saw him on their ring camera, If it was drugs, then it might lead to something.
Not for nothing but exact thing happened to me years ago.
I had been out partying, had cleaned up my spot beforehand and got real drunk.
Went home safely, woke up, realized I was standing in front of what would be my door two floors up in my apartment building.
Butt ass naked.
Dribbling piss on the floor.
What woke me up was the icy cold floor(I kept a door mat outside to wipe feet on), and I was deadass trying the knob but it wasn't working.
Went to the elevator hall to look outside, it was still dark.
Panicked, ran butt ass naked down two flights of stairs, tried my actual door, it was locked.
Ran outside, it's February or March n freezing (I live in CT), the closest safe haven is my sister's apartment, she lived like half a mile away.
Ran down the street, sticking to the bushes(it's like 3am) go to her back window(she had a first floor apartment in one of those new developments that was level with the street) knocking on her window.
She seems me, opens up n let's me in.
Still cracks jokes about it to this day(10 years at least).
So I'm not gonna say Joe deserves the benefit of the doubt, but he might.
All the doors in my apartment building had peepsites so I still have no idea or not if someone was on the other side of that door two floors up but I pray nobody was home.
Nobody else in the building ever mentioned it to me or acted funny so I think I was clear.