I had mine done 14 years ago. I didn't have any problems at all. It didn't hurt, was mildly uncomfortable for a day or two then back to normal.
There has been no change in my periods, cramps, hormones, or physically. The only effect on my sex life was an improvement. Before getting my tubes tied there was the constant worry about did I take my pill, was on any medication that would make it less effective, will I be one of the few who get pregnant on the pill, etc. With the worry of pregnancy gone, our sex life improved. Honestly, I'm very happy I had it done.
As with any procedure your doctor should tell you any risks involved. If you have questions about it, talk to your doctor more. And when the doctor tells you the risks, ask how often women have problems with getting tubes tied. Very, very few women have complications with the procedure or experience negative effects.