I think your concerns are valid. If it's expected that base layer transaction fees will only increase with adoption, then I'd expect dependence on layer 2s like LN to increase as well.
What's the cheapest hardware and internet service plan needed to run a simple payment node? Will there ever be out-of-the box solutions for non-techy people?
As you mentioned, we're talking about people's money.