I have had the endoscopy. It wasn't a big deal. The room my doctor uses for procedures was partly a file room. It had lots of moving shelves that could be pushed on their tracks to one part of the room. Files were locked, but it was the only part that was noteworthy. I mostly noticed because I would LOVE to have shelves like that in my home, LOL!
My mom has done the colonoscopy quite a few times. She says it is no big deal Even the clean out before is not really a big deal. She has even had the doctor pull her out of the sedation with the tube in so she can see what is going on. She has done this for both the colonoscopy and the endoscopy. I don't mind seeing the tapes after, but don't think I would enjoy them during the test.
I had a lot of anxiety before the endoscopy, but it really wasn't a big deal. The part that was the most unpleasant was passing the air they blow up the intestines/bowels with. They have to pump in air so that they can see everything. So it has to come out at some point. I found that the gas relief gels sold at the store (like gas X) were very helpful, as was drinking a lot of water afterward.
I hope that they can find a way to help you. While no one wants a problem, if you are feeling yucky and they find a problem they would be much closer to figuring out how to help you feel better.
Lots of gentle hugs.
oh - depending on your drive to the doctor, you may want to take a rice bag that can be heated in a microwave. Most convenience stores will let you use the microwave, as will the doctor if you ask. A heated rice bag will help with any cramping or discomfort from the air they pump in.