I had a sweep with DS2, but it was another five days before I spontaneously went into labour, so couldn't tell you whether the sweep had anything to do with it or not.
As others have said, it wasn't painful, just uncomfortable.
Maybe it makes a difference if it's not your first baby. My poor mum had one with me and I think it was an absolutely traumatic experience for her