The mistakes made by automated driving usually involve interaction with either human drivers or impaired pedestrians, if you neglect stupid shit like Teslas losing fights with fire trucks because "Cameras Are All You Need." Nonstandard or missing signs and lane markings are close to the top of the list as well.
Doing automated driving right means restructuring our entire surface transportation system to support it. I doubt it can happen without a serious commitment from government... which is in no condition to commit to anything.