This is exactly how I feel ads affect me. If I see an ad, I'm inclined to avoid the company advertising that product or service to me in future.
If I'm looking for, say, a bluetooth speaker, find an ad that looks interesting (of course I do a bit of product research), that may of more utility to me than the "frustrated, and did not buy anything" option.
However, things like Taboola are a cancer on the internet. Distracting and useless.
1. Specs 2. Reviews 3. Teardown 4. Product comparisons
Ads just don't give me any of that, the landing pages too often don't even have the specs, and I am never going to choose a brand name if their specs/reviews/teardown/price is worse than any other brand's or non-brand product's.
The only ads that "could", "maybe", "in theory" work on my are from Amazon, since free 1-day shipping is a cool thing... except I already search Amazon when I'm looking for a product, and by the time they get to show me ads about it, I've already made a purchase and are no longer interested.
If you were going to buy it anyway then the ad did nothing, if you weren't then you are now worse off as you bought something you wouldn't have otherwise -- you've been manipulated.
From this there is no such thing as a positive ad.
Also, he didn't say that ads don't work on him, they certainly do but they're not having the desired effect which makes them worthless to the advertiser. Sure, they get brand recognition but if you consciously make an effort to avoid brands which advertise to you and recommend that others avoid the brand too then you've actually cost the advertiser money, making the ad worthless.