Recently had an endoscopy at Kings with the spray, as with sedation you have to have someone there to take you home, and didn't feel it was fair asking people to take a day off for me.
Was it pleasant, not one bit, but if you do as your told ( lay on side, head on chest, swallow ! ! ) it is over fairly quickly. Just a bit of a sore throat after.
Hope all goes well, whatever you decide on x