I've had 3 over the years with no sedative or anaesthetic. In fact, I was able to watch the procedure, including polyp removals, on the screen as it happened. Absolutely no problem whatsoever. The prep, ie the industrial strength laxative that clears out the intestines before the procedure is by far the worst bit of it all. Worry not. It sounds much worse than it actually is.