Along same lines of "unexpected results to contraception", I didn't realize until after my vasectomy that some women are turned on by the fact that they could get pregnant. (I figured this out when my friend told me that his wife, the closer she gets to orgasm, starts saying she wants a baby.)