I'm also biased in favor of taking daily supplements, because I take daily supplements and don't want to feel like a fool. That said, here's some analysis of his sources:
Most of the articles he (doesn't) link to are about harmful effects of beta-carotene and vitamin A, which coincidentally turn out to be mostly the same thing, just in a different form. Checking out the one article I found [1], they gave 30mg of beta-carotene (16K UI), and 25000 UI of retinyl palmitate, which converts to a total of 41000UI of vitamin-A, or 800% of the recommended daily dosage.
That dosage is insanely high. I have a very good "mega multi" vitamin, and it only contains 200% of vitamin-A, because it is well known that vitamin A and vitamin D are one of the few vitamins that are actually harmful at large doses, and you can get poisoned/die from overdoses. It's the reason why you don't want to eat polar bear livers. To OD on vitamin A is quite easy, with effects being seen starting at daily 21000 UI doses. So no multivitamin pills actually contain that high of an amount of vitamin A. I find it strange that he's not talking about specific brands, probably because none of them contain the high amounts that are used in the articles he talks about.
It doesn't surprise me that taking 41000 UI has adverse effects, since it's known that this is already well over OD limits, and is especially risky for smokers, who have a lower OD limit.
All in all, the reasons he puts forward why mega doses are bad, are not relevant to consumer vitamin pills because the doses are not in the same ballpark. I would also like to see the amount of lives saved because of the pills - much like airbags and car belts, there might be people who die from using them especially, but there might be many more people saved as well, turning it into a net profit.