i did this too, after having two friends pass away from colon cancer.
i had the option of remaining conscious during the procedure
but opted to have them put me out(not down) when it became too uncomfortable.

i did not think to ask them for the video taope!
altough several years later i did get the DVD
video of a cat (CT)scan i had.