Hi. As far as I know, sedation is normal in the US. From what I have read people who have sedation have no pain and most sleep through or do not remember the procedure.
I elected to have mine (this morning) without sedation as I had to drive myself home.
It was not a painful experience. I had some numbing spray (it tasted of old bananas)and then laid on a bed on my left hand side. Swallowing felt a bit funny with no feeling in my throat, but it was OK. I had a plastic thing with a hole in it to hold with my front teeth. The surgeon put the endoscope in through the hole and although I could feel it a bit it was OK.
He looked at my upper tract and carried on to the stomach. That also was OK.
He did some manipulation to get to my duodenum and that pushed me in to gagging. I gagged about 8 times I guess and he took about the same amount of biopsies.
I felt bad while it was going on but as soon as the tube was out and I sat up I was fine again.
While it wasn't pleasant, the knowledge that I do not have a serious illness made it very worth while.
I could breathe through my mouth without any problem (don't ask me how that works...)
I am left a little sore if I think about it but am fine otherwise.
I very much hope yours is OK. Like I said, not pleasant, but it is all OK after and very much worth going through to check for serious problems.
Good luck.
Jim, UK