Experiences with getting your tubes tied??

I have it scheduled for two weeks and everybody is telling me not to do it. They say it’s the worst pain they ever felt or regret getting it done. I just want to know if anybody has the same experience on here?