Membrane Sweep yay or nay? 🤔

Ok ladies, what has been your experiences with the membrane sweep? My first daughter came pretty much right on time and my 2nd 5 days late. I chose not to do it with either of them because I wanted as little intervention as possible. I'm now approaching my 40 week appt with baby #3 and just wondering, should I go ahead and just do it? Or should I hold off until 41 weeks when there's a higher chance of being induced and I really just need him out? I can't decide! I was 2cm last appt, 70% effaced so midwife says she can probably do it by week 40 for sure if I want to.

If you've had it done, are you glad you did? Or did it make you miserable and lead to nothing?