I didn’t find it painful.
I lost my plug the morning after I had it and gave birth the follow night
But my water broke so I don’t exactly recommend it or at least I don’t think I’ll do it this time around because I want to deliver natural and try to keep my fluids intake

My husband's aunt had it done with 3 of her 5 kids and she said it didn't do anything either of those times, she said it was pointless and not worth going through the pain.

I have. It worked for me but my body has always labored well after my first child. I went into labor the next day.

You'll feel cramping afterwards ,I went into labor two days after but it can cause leaking and which it did with me so they kept me and had to induce me because i could've been at risk of infection

Not, I never got one, and went into labor 39 +3 naturally.