They usually offer what is called "conscious sedation" and most people have no memory of the scope. Some people have it done with a throat spray to numb the uncomfortable bit, and then watch proceedings on camera! Choose whichever you feel suits you best.
Afterwards you may be a bit groggy if you've had the drugs, so get them to repeat things and repeat back what you think they've told you. After my first one I was so stunned it was normal I think I asked them for the results about 3 times!!
New stuff: GERD, Recurrent cystitis/Overactive bladder
Lifelong stuff: Food allergies/intolerance, eczema, asthma