We have some of them in the UK and you can see the price differences quite clearly: https://agileprices.co.uk/
I think the idea of having one (or maybe a crude day/night) tariff is really antiquated now when wholesale prices swing so much because of renewables. We are getting to a place where electricity is going to be free/negative a lot of the time and very much more expensive for other time slots.
However, I don't know how much consumers can do about this apart from buying batteries (which is a good thing). I don't think many people will start eating their dinner 3 hours earlier or later or do washing in the middle of the night to save a few dollars here and there. I suppose AC/heating would use enough that it would be worth turning it down at certain times of day.
Really where all the money to be made here is being able to get cheap industrial processes that consumer a load of electricity that can be switched on and off, so only working 25% of the time. This is hard though because there is a lot of capex (and opex) to having equipment and people sitting around doing nothing when the price is too high. But I think the energy savings will be so great there will be something that comes along for this - potentially hydrogen electrolysis.