When I had my first one I was kept conscious. The scope doctor said he was just gonna give me something to take the edge off. While I could feel something it was very mild and after he said I was clean as a whistle.
Anesthesiologists are artists at what they do.