As soon as many people abandon Bitcoin there will be less tx and the miner fee goes down.
Is that a good way Bitcoin could end up though? If Bitcoin cannot scale to sustain this much load and ends up with a huge exodus of users because of it, then it'll fail as the currency/asset we currently want it to be. Remember that the number of people using BTC around the world is still very, very low. Over the years, if the number grows, then it'll just be today's issue but only worse.
Why are bitcoin fees a problem to you? Most financial institutions like fiat currency exchanges also deduct about 0.5% -1% fee for any operation like international transfer and such.
I've been around the times when BTC was $1k and I remember I had to pay around $5 for a $1k transfer. I might be wrong though, as it's a quite old memory (edit: and I wasn't using coin control at the time). As mentioned in the OP, I had to recently pay a quite large amount of money for a few transfers. This isn't something sustainable over the long-term (it barely was over the short one!).
A few days ago I wanted to use Bisq. It required me to pay $30 in fees for two transactions. That's just mining fees. The problem is with smaller inputs - the fees remain the same, but having to pay $10 for a $100 payment is definitely not something I can afford.
Even for investment purposes, it's still a bad situation imo. I've moved a few larger UTXOs with sub-5sat/vbyte fees and they're still unconfirmed although it's been quite a while. Weeks actually. Some of my money is still unconfirmed since early February with 1sat/byte fees. I have a disposable wallet from which I've moved some money back in January with 1sat/byte fees. I am still waiting for it to be confirmed so that I can throw away the seed since I expect the tx to possibly drop from the mempool at some point.
As I said, if this trend continues then larger wallets will be able to prioritize their transactions over everyone else's. This becomes a significant issue once citizens of third-world countries (or average Joes from the EU with smaller salaries) want to decentralize their economies. If the rich are still the ones prioritized and you can't pay or move your bucks, then I think at least one component of what BTC was supposed to be is failing. Imagine what Bitcoin's network would look like if PayPal suddenly had all their txs on-chain.
For reference, in Romania most of the people I know are earning $500-800. Even for $800 a month, having to pay 1.25% of your salary per each tx is imo a burden. But now there's one more issue: my coins are usually moved with coin control so I almost always move coins with just 1 single input or 2 at most. I guess the fees would've been way higher if I had to pay for multiple inputs as the tx size grows, right?..
And people like OP will return because then it will be cheap for them... for a few weeks at least
And of what use is it if this is a continuous cycle? High fees, increasing number of BTC users => exodus of users, lowering fees => higher fees (..)
You probably afford more than the average person does, so you don't see the issue. I might afford to pay $200 for a handful of txs, but for others that is half a salary (or for countries like India, a few months worth of salary).