I had acupuncture throughout my August cycle. I found it very relaxing (especially the moxa due to the warmth) but, whereas things I'd read said people often feel much more tired or energetic after a session, I didn't really feel any different after the session. Whether it was a coincidnece of not, I don't know, but that month (and since actaully) my pre-af spotting has been for fewer days and not as much.
The reason I stopped was partly because I was back off holidays (teaching) and I couldn't commit to certain times for sessions and also because OH still hasn't had SA done, so I felt I could be wasting my money if the problem doesn't ultimately lie with me.
I didn't find it painful on the whole; the needles in my tummy and back were the least painful, whereas I did not like those round my ankles, in my ears, or the one under my nose! The others didn't hurt as such, just stung a bit.
My acupuncturist was not a fertility specialist either, but there aren't really any locally.