When will this madness end?
Who is willing to pay such amounts for a transaction?

One of the things I learnt during the time the gas fee was very high is that, a lot of people who invested in Ethereum did so because of how outstanding the Ethereum blockchain is, thus the reason that Ethereum still kept growing amidst the high gas fee. Although I am not justifying the high gas fee because it is a limitation to a lot of people who want to trade, but just pointing out the unique nature of Ethereum blockchain and how valuable the community users holds and regards it.
Nevertheless, nowadays the gas fee keeps reducing, at least the last time I used it and also, the team have already shown enough interest towards working on the network to bring better services hence the ETH 2.0.
Therefore, sooner than later, the problem will be solved and more people will see another better side of Ethereum blockchain.