My daughter just had surgery on July 3. She had the foley catheter for 48 hours after surgery. It was a very minor, very quick "oooh" when they removed it. They deflate the balloon inside and it comes out very easily. No pain, no aftereffects, no big deal. And this coming from a kid who hates the thought of pain.
Don't let this be the deciding factor in having or not having surgery.