I have had the pleasure of riding a few times in SanFrancisco.
The drive was delightful and felt really safe. It handled the SF terrain, traffic and mixed traffic like trams very well.
I wouldnt trust a self driving tesla ( or any camera only systems) though!
Why wouldn't you trust a Telsa, millions of people let there Tesla drive them all over USA (not geofences like Waymo) without touching the wheel from parking spot to parking spot everyday. Have you tried it?
I took the Waymo from San Jose airport to home on the peninsula. It took the 101 highway back for the most part, driving very conservatively at 65-55 mph, and in the right most lane. It still has a few quirks though. When there aren't any cars around it will speed up to 65 mph, but at on-ramps, it will slow down to 55 and then speed up once past. It will get stuck behind slow drivers being in the right most lane and patiently follow them a few car length behind them. On the plus side, the lidar stack field of view as shown on the internal display seems to see pretty far down the highway.