I had the endoscopy a few weeks ago and found it a very traumatic experience, especially as I had two nurses holding my hands down in addition to the one at my head. I just had the throat spray and couldn't stop gagging. The tube was down there for 15 mins, which the nurses said was longer than usual. Everytime I gagged I was sending all the extra air back up which they had pumped down into my stomach, so they kept having to start again.
Glad I had it because it showed up a hernia and gastritis, but I will refuse point blank to have another without sedation.
Don't want to scare you but I'd rather be honest with you. But it sounds like other people find it a lot easier.