I am going to have to give this a hard pass.
I had a catheter inserted before my surgery. It remained in for a couple of days after. I felt no pleasure that would equate to orgasm level. and this thing was in all the way to bladder.
The only positive I had from it was the lack of urge to piss. You don't know how much you miss it, when it is suddenly gone.
The major negative...
This was the balloon type, the one that is inflated once inserted. It was a major three way assault to remove. FIRST PROBLEM: the nurse was hotter than the sun. I mean the Nurse Betty stereotype. Don't know anyone who has, but I can assure you, catheter + erection = painful, no matter how much lube is applied. SECOND PROBLEM: She had a large needle near my wang to deflate it. To do this she had to hold it. While I can see her victoria secrets. She was trying to distract me, as I felt the needle push through the tube to the balloon. I could not see anything, because she had to move my balls, and I had to close my eyes, so I was not watching. My balls were snug against my cock. THIRD PROBLEM: The removal. I did not feel it go in when they put it in, because they had already started the anesthesia, because my lung could not handle the gas. So I was flying high as they put the thing in. But the balloon deflated was twice the radius of the tube, so this nurse was holding my john thompson while agonizingly slowly pulling this thing out until the balloon was out of my bladder. Then it was a quick sharp pull. I dared not open my eyes for fear my man stick would be hanging on the tube in her hand. Then I came. The pain, and her holding my cock was a bit much for my morphine addled brain, and I must have pumped out a gallon, but still not looking. She was quick on the draw though, using a glove like a condom when she got it out.
As for wanting to insert anything into my urethra for pleasure. No. Also I seen enough weird shit online with people putting things in there to know that I want no part of it. The most and close to what I will allow is my wife's nail a little, and thats only scraping it for the pre cum on her finger to taste.