I believe the idea is that a small transaction fee will be expected by the majority of miners, which will make a flood of transactions costly.

Miners are free to include/exclude your transaction in their block regardless of whether a transaction fee was included. If the majority rejects transactions without a fee then it will take a longer time for the transaction to be included in a block.