You're not really meant to take omeprazole for more than a few months, though I know lots of doctors prescribe it for years. Suppressing the production of stomach acid comes with its own problems long term, as it's so important for good digestion. There are some great videos on YouTube for how to address it with diet and supplements.. Apple cider vinegar (with 'the mother', which is where most of the benefits are found) is one of the things that's recommended that I've found helpful. I buy it online from Natures Best, it's a good brand (Ostlers), and tastes a bit better than others I've tried. I dilute 2 tsp in a small glass of water with some lemon juice, and add some stevia as otherwise it's very sharp and pretty unpleasant. It's a beneficial thing to take generally.
I had a bronchoscopy under sedation a few years ago, so similar to an endoscopy, and was dreading it too. It was so much better than I expected, the anaesthetic throat spray was the worst part, funnily enough, and other than that it was absolutely fine. I didn't feel the tube go down, and the next thing I knew I was waking up and it was all over. I'm a great enthusiast of sedation now!