Had one when my second child was about 2. Fantastic decision.

The procedure itself was painless, just felt like pinching and pressure, as everything had been numbed beforehand. Followed it up with three days of lying in bed on pain killers watching TV with ice on my balls. After a few days, maybe up to a week, everything felt back to normal.

No condoms anymore, no risk of an oops.