Well, when advertising outright deters people from buying the product it's trying to sell, I think that's basically the definition of failure.
Some marketing is so good that it produces a negative net balance of buyers =p, money well spent.
It's not marketing, but in 90s eastern europe had some underground game translation and 'publishing' companies if you know what I mean. Some of their absurd translations have become folklore, for example they translated Tomb Raider as Томбовский Рейдер which translated back to English means Tombian Raider, like Tomb meant a city, a country or a nation. Some games had so trashy voice acting you wouldn't believe.
Don't we love shoddy amateur work?
duduspace11 "Well, since we are estimating costs, Pokemon Red/Blue did cost Nintendo about $50m to make back in 1996"
Mr Puggsly: "Hehe, I said good profit. You said big profit. Frankly, not losing money is what I meant by good. Don't get hung up on semantics"
Azzanation: "PS5 wouldn't sold out at launch without scalpers."