What is the Bitcoin transaction fee for $1,000 dollars

If a block can accommodate around 2400 transactions, and as the block reward diminishes, miners increasingly rely on transaction fees for their rewards, why would a miner bother including small transactions in their blocks?

As a miner, it seems more lucrative to prioritize 2400 transactions each valued at $1,000 with a 1% transaction fee, rather than including 2400 transactions each valued at $1 with the same 1% transaction fee, as the effort involved is the same. Alternatively, is the expectation that one should engage in a $1 transaction but incur a $10 transaction fee?