Nelie,
It's not awful at all. They would wheel me in, put oxygen in my nose, turn on the I.V. and next thing I knew I was waking up after it was over. What I had was not surgery...they just stick a probe down there and dilate or stretch the esophagus.
Believe me, even getting the scope down your nose during routine doctor visits is worse. I have no memory of anything but the before and after, both of which were not unpleasant at all.

Best of luck...I too, spent many months tube feeding while others ate, so I know how you feel.

Danny G.