Yes, I agree, especially, for me with things like flying birds, but I still get a lot of mis-focussed flying bird photographs, and in bird photographs where the bird is partially hidden by branches and I can't manage to get the single point AF locked onto the bird.
With people and eye detection, it will often choose the wrong eye, or decide something closer than the actual subject looks more like an eye, than a real eye does.
With so called "intimate" landscapes, even the pinpoint AF is too big to grab the flower ( or other object) that I want to focus on within a larger scene.
And while I am getting better at changing the AF settings to suit different circumstances, I'm also still using manual focussing or zone focussing a fair amount of the time, because I find it more reliable and predictable.
Don't get me wrong, I love AF, but it's also, at times, exceptionally annoying. And a lot of the time I still prefer the stronger connection with the subject that careful manual focus brings: keeping AF for when I see the benefit.
I rarely get the focus wrong with manual or zone focussing. But I also have pictures, which I would have stood no chance of getting without AF, and I am appreciating the maasive improvements in AF that my Z8 brought over my D500 it replaced.