I honestly don't think we will have a clear answer to this question anytime soon. People will be in their camps and thats that.
Just to clarify, have you ridden in a Waymo? It didn't seem entirely clear if you just experienced living with Waymo or have ridden in it.
I tried it a few times in LA. What an amazing magical experience. I do agree with most of your assertions. It is just a super careful driver but it does not have the full common sense that a driver in a hectic city like LA has. Sometimes you gotta be more 'human' and that means having the intuition to discard the rules in the heat of the moment (ex. being conscious of how cyclists think instead of just blindly following the rules carefully, this is cultural and computers dont do 'culture').
Waymo has replaced my (infrequent) use of Uber/Lyft in 80% of cases ever since they opened to the public via waitlist. The product is pretty good most of the time, I just think the odd long-tail behaviors become a guarantee as you scale up.
You have to consider that the AVs have their every move recorded. Even a human wouldn't drive more aggressively under those circumstances.
Probably what will happen in the longer term is that rules of the road will be slightly different for AVs to allow for their different performance.