My dad had this done. He said the worse thing was the roto-router drink since he had to stay very close to the toilet while it cleaned him out. He said the procedure itself was not a problem.
PS - I get to have my first one this year also. Or will, once I see my Primary Doc.