My girlfriend had hers and watched the whole thing. They gave her some type of anti-anxiety drug but I'm not sure what type. She said she talked to her doctor the whole time. Not me though, I'm a wimp and went with the nap approach!
Propofol would be the next anesthesia of choice for procedures. When i had my endoscopys, they used propofol to put me under. Yes it can be a dangerous drug if the anesthesiologist doesnt know what they are doing, but they usually do. It started to become controversial after michael jackson died, but he abused the drug. In my opinion, it is a completely safe type of anesthesia. The anesthesiologist intently watches your heart rate and breathing, and if there are any complications, you are immediatly brought back to conciousness using a reversal drug. Althought there are risks for sure, i would not be too worried about it