I don't know about almost zero, but I feel like cheap fees should still be a priority going forward. Cheaper fees than ones charged by third party payment processors was one of the primary selling points of Bitcoin, and Satoshi even addressed it in the introduction part of the white paper:
The cost of mediation increases transaction costs, limiting the minimum practical transaction size and cutting off the possibility for small casual transactions, and there is a broader cost in the loss of ability to make non-reversible payments for nonreversible services.
I don't think it necessarily has to scale to be able to accommodate microtransactions (there are workarounds after all, like LN), but at the same time should have enough use cases to remain plausible for the middle class. It could be argued that there's a price to pay for decentralization, immutability, etc., but realistically speaking, the average joe wouldn't care about that. It's difficult enough to convince people to use Bitcoin, and pricing them out with fees they would be uncomfortable with wouldn't be the best idea.