I don't have a good answer for this, but the fees are the price of doing business. If I want one Satoshi then I really want 1,000 mSats. In this case I would want a solution where I set up a system to earn more from small transactions.

Bitcoin on Chain is settlement. That's important. We are batch settling transactions for a time period.

This doesn't answer your question but it may be that your question is ignoring other solutions that already address small transactions.

You can always send Bitcoin back and forth to your self and FAFO what the smallest is. Be aware that locking your sats into UTXOs that in the future exceed the value of a transaction is not good. At least with Fiat a penny jar has value so this is a good way to view running lightning for yourself. Get your mSats penny jar in circulation for the next phase when the pennies buy houses.

At the point pennies buy houses you'll have another technology that is built to circulate a smaller denomination that settles on lightning. Currently the theoretical limit of maximum Bitcoin mSats is 2.1 quintillion.