I had mine done 7 years ago now and it's the best thing I ever did. Wish I did it 20 years ago, but I'm happy I had my kids so it's all good and better late than never.
I've confirmed via lab results that I'm firing blanks so no worries about slipping one past the goalie with whoever I may hook up with. Its paid for itself already as I really hate condoms as they rob me of all feeling and I have a very hard time finishing with one on, so if I'm with my wife who is not on any birth control now or someone else that I'm confident is clean I can really enjoy myself.
I still wear a raincoat with escorts of course, I'm not that crazy.
As for the process itself, its uncomfortable but doable. It's the week after that sucked for me, a couple days where I had to be laying down as when I'd stand up the blood would rush down and it felt like I got hit in the junk with a 2x4 and was unbearable.
When the Dr says don't cum for a week after the procedure listen to that advice. I was worried so I took myself for a test drive on day 3 post op to make sure it still works and busting a nut felt just like it sounds and was very painful. Don't worry, it'll work, just be patient and give it time to heal.
I talked to the Dr about prostate and cancer and any other issues and he said that there is not enough correlation to confirm the rumors. So many positive case results to so few negatives. Time will tell...