A very nutshell summary is that the minor benefits are accompanied by minor drawbacks. For example you'll not get much benefit if dragged under a 16-wheeler and research shows that drivers will come closer when overtaking someone wearing a helmet.
A major problem though is that well-meaning types want to legally enforce helmets in the name of safety. An immediate impact of this would be to reduce cycling amongst those who think helmets are a nuisance or uncool (as well as another reason for cops to hassle the poor/minorities for breaking laws that they won't bother the better off about). It's fairly well documented that more cyclists/cycling means safer cycling so anything that discourages cycling makes the remaining cyclists less safe.
But I'm not convince that the benefit of helmets for cyclists far exceeds the benefit of the same helmets on pedestrians, or on car passengers. Now, most people agree that there's a comfort/price/benefit compromise, which makes it inappropriate to enforce mandatory helmets onto pedestrians, although it would obviously save some lives. In order to accept that what applies to pedestrians doesn't apply to cyclists, I'd like to get some hard data, not some "gut feeling" from lawmakers who barely read what they vote for.
Also, I could understand that serious head traumas avoided in significant numbers would justify a law: in most civilized countries, the corresponding hospital bills and disability grants are paid by public insurance, i.e. taxpayers; cyclist are therefore accountable in front of them. But if it mostly saves scalps from roadrashes, I don't think that a law is appropriate.
Do you really believe bicycle helmets are completely ineffective? I'm going to have to call [citation needed] on that, because having at some hard padded thing on my head seems like it should at least help somewhat. Concussions, etc.