I agree most of them are surprisingly good -- the forward collision warning system on my Golf R only made a few mistakes in the 3 years I owned it, and they were all "understandable" mistakes where the tech clearly didn't understand why it was 'wrong' -- eg, I refused to lift throttle because I knew the car in front of me was about to accelerate due to the light which had just turned green, or I elected not to brake because the car cutting in front of me was swooping across two lanes so it wasn't worth panicking about.
The system on my Model 3 is GREAT, but only when set to "late" ; my aunt's car was constantly hassling her until I found the setting and moved it from normal to late.
But there are other such annoying automated systems -- my Golf had a REAR collision warning which would fully engage the brakes if you were reversing down your driveway while a car was driving down the street behind you. I suppose it wanted me to wait until the road had NO traffic before daring to reverse on my own private property.
Also, some cars try to overthink things for you. I've driven vehicles where if you drive in a spirited manner, lifting off the throttle abruptly and engaging the brakes quickly but not aggressively, it decides you MUST want to perform a panic stop and doubles the brake pressure. I think most of us can agree that we want our machines to perform in a reliable and consistent manner and not have basic controls second guess us?