TPS can be increased either by making the blocks larger or by increasing the number of average blocks per minute/10 minutes. If the number of blocks is increased, the probability of double spending will be higher, which makes some services set a limit of 10 confirmations before the transaction is considered valid, or by increasing the size of the blocks, and here it should be. A reasonable increase, for example, is less than 32 MB. Therefore, there must be a certain TPS limit to say that the network is decentralized and secure, so that obtaining a single confirmation makes the transaction final in most cases.
This is only possible by increasing the size of the blocks and not making a comparison with central services such as Visa and MasterCard, otherwise the resulting solutions will increase the number of confirmations.
That's the problem. Developers are laser-focused on beating down Visa and Mastercard, without realizing the cost of doing so. By increasing TPS, they would be reducing the Blockchain's level of decentralization in the long run. You can't just have the "best of both worlds". I'm afraid crypto's limitations will persist for a very long time. Because of this, it will never replace Fiat as the dominant force of the global economy.
At least, people will be able to get true financial freedom. The most capable public blockchain networks (XRP, SOL) are sure to get greater adoption over time. Probably even more than BTC and ETH combined. The higher the number of TPS, the faster mainstream adoption/demand will increase. Hopefully, old blockchain networks (BTC, ETH) would solve their scaling problems for greater acceptance worldwide. As long as decentralization wins, nothing else matters. Just my opinion