My name is Marsha, and although I don't have an urostomy, ( I have an ileostomy) I've had about 12 surgical procedures in the last 50 years.... some related to the ostomy...others not.
But each procedure came with it's own anxieties, and issues. Years ago, they really kept you in the hospital longer, so pain management, and complications were handled there. These days, hospitals & insurance, tries to get you out as quickly as possible.
My suggestion to you is to speak to your doctor before surgery, and make sure you'll have pain meds on demand, if you need them. I had kidney stone surgery removal last winter....and I can honestly say I felt no pain. But I did have other complications, so it's always helpful to have a friend or family member around to advocate for you. If you don't think youre ready to go home....then fight to stay longer. The reverse is also true....
I think I've had more catheters / drains removed than I can count. And that's what they usually have you do....count...even if it hurts...it passes quickly.
Recovery can be tricky. It always feels better to "just stay put", but getting up and about as soon as possible, doing a little more each day, is really the best way to recover . Most important is to recognize when "enough is enough", and rest when you need to. I've learned over the years, and with each procedure, to have "no expectations", and just to go with the flow. Sorry...didn't mean to be "Punny:. Best of luck to you.