This really has very little to do with consumers and everything to do with a tug of war between processors, banks and businesses. I'm skeptical that any potential savings to businesses is going to be passed on to consumers.
From a personal perspective, I'll miss rewards cards if they go away. I make all my purchases with plastic and pay off the balances in full every month. In 2022, I received $711 in cash back.