My husband got one and I say sex is better and more frequent (at least for me, I can't really speak for him, but he seems pretty happy) because there's no risk of an unplanned pregnancy and I am certain that the childbearing years of my life have past, emotionally. We can be more spontaneous. I love that. No erectile problems, there's no biological reason for that to happen.
He did not love the idea of having one, and I volunteered but the cost/ downtime was much worse for me. I had been through two extremely tough births -- my midwife said my last birth was one of the toughest she'd witnessed and she'd delivered 500 by then -- and more than enough pregnancies that did not end in a live birth so I did not have a ton of sympathy for his hesitation regarding his jewels, to be honest. He said I had to look into it and I said no, it did ultimately have to be something he does and does willingly.
It took him a year, but he finally did it. I'm really happy about it and he's never expressed an ounce of remorse. It cost us $450, but some insurances do cover it, I've heard.