I know someone who said he had lingering pain for several months after the procedure. I also know lots of other couples who have had this done, and haven't had any problems (or at least not told me about it) I have heard that spontaneous reversal, or whatever it is officially called, is fairly common, and can happen many years later, but don't know anyone to whom this has happened.
NFP is not an option for me, I get pregnant way to easily and I would be scared to death to DTD--ever!! i can't tolerate hormonal b/c anymore, and abstinence isn't really an option either :) So, having one of us "sterilized" is our best choice...I need to do more research on this issue, for sure, before we take the plunge, so to speak. I am expecting my fourth in sept, so i have a little time to read more. This pregnancy was an unplanned "oops" because I thought I was safe still nursing ds so much, and my cycles were nowhere near regular. This is why NFP is not for me.