I have been getting acupuncture for a while now for a variety of things including diet, sleep and stress. My guy is very helpful and offers practical advice on a whole bunch of things, he's been doing acupuncture for ages and he is also a registered psychologist and nutritionist. He doesn't prescribe any medicinal herbs as I guess it's not required. I've noticed an improvement in my overall health by getting regular treatments (usually once a week, for three weeks in a row, every six weeks) making simple changes which he recommended for my lifestyle from day to day, just little things in combination.
Just a warning, I often find it difficult to "relax" when someone is sticking needles into me (I totally hate it) especially when sometimes it can hurt if I am especially unbalanced/stressed/whatever. Which goes to show how much I benefit from it, that its worth the discomfort. Generally speaking you shouldn't be in massive pain though, for the most part you just lie quietly for however long and it's quite relaxing, but I don't recommend falling asleep in case you move and bump one of the needles. My first appointment I remember it just felt like a little finger tap along the points in my arm/hand/leg/feet and I was like "So... Is that it? What do I do now?" and he said just focus on breathing slowly. This in itself is a very good thing, if you are like me and can't really meditate- there's nothing quite like being literally "pinned down" and unable to physically move so you are forced to do some mental housekeeping. It reminds me what it feels like to have a somewhat clear(er) head and sanity, pleasant, even if it only lasts for the next few hours before the mind goes back into overdrive. I usually sleep well/better that night.
I was amazed that he told me to avoid certain foods before I even found out I was allergic to them and had a variety of intolerances and had been eating everything on a regular basis which was causing too much "heat"/inflammation in my body and damaging my stomach and affecting my emotional health too. (Interesting tidbit- I've heard it said that your digestive system or your gut is your emotional brain, this has proven true to a large degree in my experience. When I was at my lowest mentally, my body was suffering a great deal too. My GP also told me, if your body is getting what it needs then you have more resilience and energy and have a better chance of fighting things off in more ways than one, and vice versa. Kind of chicken and the egg...). So now I don't have as much pain in my stomach/gut, my hair isn't falling out, no more itchy hives and rashes, etc etc etc gee I sound delightful hey? lol
Sometimes I get emotional but that's complicated (hormones and PTSD stuff) and sort of like a release of nervous energy and tension. Usually if I am in a bad state (headaches/migraines) he might put a needle in a certain spot between my brows or in the top of my head in my hair (then I look like I've had 12 hours sleep afterwards, because I guess it must relax the muscle). Which reminds me of yoga, how doing certain poses and stretches can "release" emotional pressure... I recommend that too.
Don't think I have much more to say re acupuncture except that its something I found works for me, but requires some of my own effort and persistence. A one off treatment wouldn't have helped much in my circumstances although I noticed an improvement straight away, it was a verrrry gradual process to achieve this level of health (still a work in progress). Wear loose/comfortable clothes. Make sure your practitioner is officially registered and... that you feel you can trust them (well- I felt quite vulnerable). I have only ever been to this acupuncturist so I don't know what others would be like but I suppose like most other health professionals, they vary in personality/experience/compatibility so if the first one doesn't suit you then perhaps another will.
I feel like I've just shared something really intimate or... something lol. Good luck, I hope you find it a positive and helpful experience. Let us know how it goes :)