For me,
having a catheter wasn't a problem. Just lay in the bed and every so often the nurse comes in and drains the bag. I never got an urge to "go", it just quietly drained out.
Until they told me about "bladder training." This required me to disconnect the tube (there is a connector for this about 12" (30cm) from the body which occasionally created an uncomfortable feeling because the pressure in the tube changed during process, but the pressure in the bladder did not. I taught myself by trial and error how to minimize the change, but was still surprised sometimes.
After disconnecting sitting up and getting out of bed was pretty painful. I didn't ask for any painkillers, I figured it's best to not use those unless ABSOLUTELY necessary. Once up, walking wasn't that bad, but sitting down was also uncomfortable. And once down, the catheter seemed to stop working...I'd have very bad pain and urine would flow AROUND the catheter. The nurse told me this is a good sign (I forget why) but urinating with a catheter was always difficult while sitting (I didn't try standing up, that might've been better).
Same thing happened when they removed the catheter...very low flow with very little urine. I told the nurses and they said it was likely a blood clot, which they removed using a different style of catheter.
No problems or pain since then.
BTW, have you ever seen those small lawn sprinklers with a little "fan" which disperses the water? That is how the first few weeks is like when peeing.
Despite all my talk about pain etc, I'd do it again if "it" grew back somehow. It's worth it.