One bit of advice I can offer is that I myself have had en endoscopy done and you don’t remember a thing.  The sedation might as well be an anasethetic. It’s an easy procedure to get through and you are not sore afterwards at all.