I’ve had several colonoscopies and just the one Gastroscopy.
I only had the throat spray. Not a pleasant experience, but not that bad. Quickly done and then you are free to go home with no hanging around waiting for the sedation to wear off.
Nice nurses and doctor at St.Mary’s Hospital Pompey.