I truly don't care. I would much rather miss out on hearing about a few genuinely-desirable products due to poor discoverability, if the payoff is that I don't have to suffer the deluge of imposed advertizing I never asked for.

There is absolutely no reason to think that advertising makes discoverability of desirable trades more likely, and every reason to think it makes it worse. The people best equipped to spend a lot on ads are those who are offering the worst deal (giving them the best margins). That's without even getting into ads that are used to manipulate people into wanting to make obviously bad choices, e.g. ads for soda, candy, fast food, alcohol, gambling, pointless plastic garbage, etc.

Obviously specifics make a huge difference here so it's hard to generalize, but generally, finding the market is not a new problem. In the current business environment, the entire ecosystem is rigged against you, forcing you to advertise. Consumers are so inundated with advertising that almost have no energy leftover, or any expectation that they need to go out and search. Worse, search is distorted in all the wrong ways because of the exact same incentives. Your competitors (or even poorly-fitting tangentially-related products) are stealing discovery from you by capturing searches through advertising. They can't even get to you because a wall of SEO stands between them and you.

In the 90s I would spend my money buying a magazine called computer shopper when to wanted to shop for computer parts.

That’s opt in advertising.

But you as the advertiser is not happy with that