Please be careful with your contradictions. There are controlled clinical studies - which you refer to yourself two sentences later.
There is evidence of a beneficial effect from some treatments - which you also refer to. Pain reduction is a clinically beneficial effect. So is 'feeling better'.
If it doesn't matter where you put the needles, but you still need the needles for the effect, then the practitioners are mistaken about what is important, but you still need the needles.
(Note that acupuncture studies don't all conclude that needle location doesn't matter, though some do; each study typically tests one specific set of treatment locations, and acupuncture is notoriously hard to perform controlled studies on because the purportedly most effective treatments are excluded by the requirements of controlled studies).
As you say, some of them elicit a powerful placebo response. "Powerful" or "doesn't work" - choose one.
If you require a treatment to be understood fully by its practitioner and are not interested in powerful placebo effects for yourself, that's fine for you, but it's an error to say they do no good for anyone.
(You will also rule out a lot of conventional healthcare by that).
Personally I'll take the placebo if it fixes my problem and be glad of it. If the problem is pain, or insomnia, or indigestion, all of which are realistic targets for that sort of treatment, that's good done.
Pragmatism wins over principle when the end-goal of medicine is to alleviate suffering.
There is a mistake often propagated that if something is apparently placebo-equivalent, then you could have the same benefit by simply thinking yourself better without doing anything.
I think many people's reaction against treatments with a weak evidence base is their scam-filter. If the practitioner's explanation isn't scientifically convincing or they are clearly not right about something, they must be a scam and people should be protected from scams - and people do fall for scams, often.
But the fact is, lots of people use them and lots of those people experience a benefit which goes deeper than "the patient feels happier because they think they had a treatment".