Most people have too much depend that is fixed for spot prices to make sense. If you have two meters putting one on spot might make sense - but that only works if there is something is stopping you from changing what meter is active.
Too many people think about the above two because it’s easier to see/feel/touch while it’s really thermal loads that are the bulk of household loads.
If I have to go down to 15C or deal with 30C, delay my shower/dishwasher/clothes washer/dryer to save enough bucks when it could really count, I’d do it.
Meanwhile on fixed pricing, I turn things off when prices are negative (that’s bad!) and indifferent to high prices when I have zero incentive to do differently.
I know my parents got half price electric for water heating, but I don't know how much they actually saved.