Sounds like an incredible hassle at a level I would pay hundreds of dollars per month to avoid. That sort of mental overhead is crazy to me. But I'm also someone who finds having a single event on my calendar for the day disrupts my productivity and mental peace to an absurd level.
Time of day billing is definitely the future for renewables though, once they hit a saturation point for the grid it's the only thing that makes any sort of sense. Perhaps residential is the last place it needs to happen, but eventually it will be the norm. I see it working more in an automated fashion though. Smart load centers (panels), smart appliances, etc. that are connected to the local power company's API. Then you set some rules around it.
Stuff like cooking dinner though? I cannot imagine planning my day around saving a couple bucks. That's just insane to me. Energy use and all this mechanization/automation/technology exists to make life more convenient in the first place! Stuff like EV charging, raising/lowering temps in anticipation of power pricing, laundry (dryer) scheduling, etc. seems to be where 80% of the wins can be made, and are all much more automatable to avoid having to think about it. That last 20% can simply be taken up by whole-home battery storage, which by the time any of this happens at scale will be pretty much the norm.
The thing that concerns me most though are regional "seasonal" events where a once-a-decade lul in energy production happens and there is simply not enough dispatchable power on the grid to meet demand due to everyone hyper-optimizing their loads in such a fashion.