mcrue,
My first catheter experience was in 1969 when I was 12 for a urethral stricture that was surgically mended. Back then it was a traumatizing experience to be sure as it most likely would for most kids that age.
It wasn't until 2005 when I had the AN and shunt surgeries (plus another urethral surgery 5 years later) that I came to relive the experience, albeit as an adult. In the ICU (for two days) I was completely intubated, including a feeding tube that made breathing difficult and talking impossible. The feeding tube was so uncomfortable I ended up pulling the thing out on my own in frustration because I couldn't breath. It was like that scene in the movie "The Matrix" when Neo wakes up in the pod and pulls that thing out of his gullet. The nurses freaked out, "You can't do that!" I paid for it by not eating for over over a week, living off the IV. I had to prove to them I could swallow. They had to run a fiber optic tube up my nose that snaked through a sinus passage and down my throat (which also curiously did not hurt).
At one point after the catheter had been removed in my hospital room, I developed a painful UTI that required having the catheter reinserted while being flushed with Cipro. The nurse said "We'll have to put it back in" to which I responded, "No, no, no!" and he came back with "Yes, yes, yes!". This time, I was fully conscious and braced myself. The burning and discomfort from the UTI immediately stopped. To my chagrin, the insertion didn't bother me! The same when it was removed: no problem.
Several years later, after having another urethral surgery, I was catheterized again and had to return home after an overnight wearing a bag for a week. When it came time to remove it, I was told I could pull it out myself. The doctors assistant walked me through it on the phone after reassuring me there was nothing to it. She was right. I had to cut a small extension of the tube to release water and air that inflated a small balloon that held the catheter in place. After that she said, "Now you'll pull it out gently on the count of three.....1, 2, 3......It glided out effortlessly. I was amazed, after having lived in so much fear of the thing for so long. She said, "I told ya!" Of course I was impotent for about a week after (another weird experience), but it all came back.