Hi Pansy
My husband had a colonoscopy a few months back, and yes the piccolax was the worst part of it. When I picked him up from the hospital he was a tiny bit dozy, but otherwise fine, and able to come straight home and have some food. He was more worried about me as I hate hospitals (I have a vomit phobia) and I was terrified whilst picking him up, but trying to be really calm and reassuring for him.
I've had horrible dental procedures without sedation because I can't imagine losing that control and fear of it making me queasy, so I understand where you're coming from.
Hope it all goes well as I'm sure it will!
XX