They give you freaking propofol for a colonoscopy?!
Yes, and its great. They get the IV in place, the anesthesiologist and surgeon nod, say lets go, you get a weird metallic taste in your mouth, and then its 45 minutes later. No real side effects, very easy to take, little groggy/out of it the rest of the day. Just want to sit in the recliner and watch TV.
Michael Jackson knew what he liked, just get a VERY competent CRNA to monitor you.