Attitude is important. I know I have to get it done and based on what the neuro was telling me want to get it done to prevent damage from back flow due to retention. My attitude going in to this is that it hopefully will prevent more problems.
However, I never heard of it being unpleasant. Cricket you made a very good point. The more uptight one is the worse it would be as you would tense up.

That is true with most things.