You can read a bit about your herbal formula here: http://www.lifestrong.com/html/product_categories/product_list/feng_shi_xiao_tong_wan.html
Dampness and Kidney deficiency are a common diagnoses in Chinese medicine. The formula is consistent with what you were told. Tongue diagnosis as well as pulse diagnosis is usually done before an acupuncture treatment. Observing your eyes and complexion is a good thing for a practitioner to do.
I was not there with you, but acupuncture in California is highly regulated so odds are you were not in any danger. Still, you have to be a wise consumer and you should select someone you trust. I have been to doctors, dentists, chiropractors, etc. that I felt were a waste of time. I have been to great ones, too. It sounds like you two did not click, and maybe the practitioner was skilled but had a hard-sell style and saw you as a one-shot deal. That says more about the individual person than the profession.
By the way, I am pretty sure that the correct formula name is Feng Shi Xiao Tong Wan (wind dampness formula or aka arthritis formula) so you can do a search for that if you like.
You did not mention anything about the acupuncture treatment itself, so I am hoping that it was good :D