Midazolam and a tiny dose of propofol can make the experience as never happened. Don't worry! Talk with your doctor and discuss all your fears. Good luck with it and I hope everything turns up well!
What did you do in the end? I had both combined, gastroscopy and colonoscopy earlier this month. Already being underweight, I managed to lose half a stone from the fasting and klean-prep (there is NOTHING worse than klean prep). You're supposed to have 3 litres at least, I managed less than 2. My gastroscopy (stomach one) was fine, they took biopsies though...colonoscopy, large bowel fine small bowel possibility of being inflamed, probably going to have a small-bowel follow-through when the biopsies come back. I was extremely weak and babbled at them that I wanted to be knocked out completely before I went in. When they started I was still alert and awake...I remember vicious pain and then..nothing. Would not go through something like that conscious, personally. Found the prep and weakness from the day before much worse than the actual experience the day of though. Am on Colofac now, Motillium occassionally to stop me feeling so full so fast. Came off Colpermin, didn't think it was strong enough. Buscopan worked and then stopped working..Spasmonal never worked. Nothing's really helping with the awful bloating and discomfort though..have ruled out pasta..other gluten based stuff seems to be okay. Also spicy food and REALLY fatty food is out the window. Almost everything has some effect though. Can't go on those awful restrictive diets because I'll lose loads of weight on them. Blerugh.