I still think there are some adaptations that could be done to mitigate that problem, but the grid seems simply not correctly set up to efficiently use the energy produced by millions of people generating a lot of power during the day and draining a lot at night.
Yes, it will be complicated, but these providers also think we all care about itemization of generation, transmission, distribution, power factor, grid line loss and debt retirement charges. I don’t, all I care about is fixed cost and variable cost.
Maybe let people overpay through some hedging contract if they prefer to pay an average price.
For me, I want my dryer, A/C, water heater, etc. to throttle up and down based on price to lower my bill overall without reducing quality of life.
Grid attached solar is a lot more attractive when your generation is at substantially at peak rates and your morning/evening grid usage is at part-peak or off-peak rates.