This is the sort of thing that really needs to be questioned.
1. How much security do we need for this transaction?
2. For this block of transactions?
3. Can we have varying levels of security?
What we are ultimately trying to know is, is it profitable to double spend? If the answer is yes, then no one should be transacting, and anything they do transact is a gamble. If the answer is no, there's much less risk, and the farther the answer is no, the safer the transaction.
But we likely don't need as much security as we do now. In fact, it's very easy to handle at a user level.
A. Put the transaction on the blockchain.
B. Wait for additional blocks.
C. If your transaction is huge, wait for more additional blocks. Wait a week, a month. This is an important transaction. When the blockchain has not reverted for such a long time, finally do the transaction in the real world.
If you are transacting with yourself, you don't need any security at all. If you are transacting with a bar and the bar knows you, much like a tab, you don't need much security. If you are transacting with an anonymous person, you want high security.
So security is currently handled on a blockchain by blockchain basis, where it should be a transaction by transaction basis. What if you can't wait a month? Then you should put heavy fees on that transaction and it should be put in with other higher fee transactions.
4. How does security change with transaction size? Does it make sense to have limits?
5. How does security change with total transaction block size? Does it make sense to have limits?
6. When the coin price goes up, how does that change these factors?
7. When the mining reward in coins drops, how does that affect security?
8. When Bitcoin, in 100 years, moves to 100% transaction fee system, what happens to security? What would the transactions fees look like?
9. In 50 years when the block reward has been halved 5 times, either the price of Bitcoin moves to $1 million, or the security drops. Is that okay?