Apparently upper GI endoscopy procedures are conducted under very very mild sedation, I believe typically using propofol.

The most recent one I got, I had disturbing hazy dreams the next two nights where I was conscious of the scope down my esophagus. I would not be surprised if it was less dream and more of a memory fragment.