I'm not a fan of hormonal contraception so we used condoms for ages. I had thought I might get fitted for a diaphragm but then DH suggested after our 2nd he might have a vasectomy. (I think he felt better about it because about 4 of his mates did it and one even had a vasectomy party, LOL!)
Honestly, we haven't looked back. There was pain afterwards but that only lasted a few days. Probably DH was more put out by the embarrassment of having a doctor touch his nads. (There's no way he could've suffered the indignity of having babies, lol. Or Brazilians for that matter )
It has made a fairly significant difference to our sex life as well. I am certainly up for it more now and I suppose that's a psychological thing - knowing that the chance of our conceiving now is next to nothing (understanding that it is possible for the vas to heal up and re-join - possible but unlikely) and somehow that makes me less inhibited.