Ideally, you want to pay the ad platform for sending you a user who will buy your product. So you say something like: "I'll pay you X for every user you send me who buys something".
Great, right?
Except now the ad can simply optimize for users who were GOING to buy your product anyway. So now you've spent money getting users who would have been there anyway.
What you really want is to pay for users "Who buy my product, but would NOT have bought it without the presence of the ad". And that's a much harder thing to measure.
Brand advertising is built around the concept of "When a person is making a buying decision, I want them to buy my product."
We know it works, because when you stop doing brand advertising for things like Toilet Paper, Detergent, Toothpaste, Deoderant, etc... sales go down. And when you start the advertising again, sales go up.
Price, Value, Placement, and, obviously, competition are all conflating factors as well - but the underlying response to advertising has been pretty consistent.
The second issue is alot of internet advertising is bullshit, including the metrics. Now, some things are good--actual-purchase links are decent data, but again that's really lead-gen not advertising.
If your lead already wants to buy your product, its too late for advertsing and you're really more into a different game. Nobody looks at an ad in the superbowl and the runs out and buy something 12 minutes later. The fact your narrative doesn't apply to that case is more a sign that something is missing in it, not that superbowl ads are mis-priced per se.