I did the math on this once. For residential it is not realistic due to the amount of water you would need to store. For commercial I think you would need a small lake.
To your underlying point, none of the added complexity is worth the effort unless a) the utility is paying you to take the excess load and/or b) someone really innovates on a slick, simple package.