I've added this update to the first post, but I thought I'd add it in-line here as well.
Update 11-29-2020
OK, I did an AF speed test with the Z6, Z6ii and the D850. I used my 600 F/4, 200-500, 500PF, and the 24-70 S series lens.
You're not gonna like this if you're a Z fan...
There's no significant improvement in AF speed with adapted lenses that I can detect with my tests. The tests were from minimum focus distance to infinity. Here are the results:
600mm
Z6ii = 1.5 seconds
Z6 = 1.4 seconds
D850 = 0.5 seconds
I honestly have no idea why the Z cameras were so slow with that lens. I ran the test multiple times and the results were the same each time.
200-500mm
Z6ii = 0.9 seconds
Z6 = 1 second
D850 = 0.8 seconds
In this case, I think the cameras can all drive the lens pretty much as fast as it can go.
500PF
Z6ii = 0.7 seconds
Z6 = 1 second
D850 = 0.4 seconds
Here, we see the Z6ii does hold a slight advantage, but no where near as fast as the D850.
24-70 Z
Z6 = 0.7 seconds
Z6ii = 0.7 seconds
So, neck and neck there.
Overall, AF speed is roughly the same, at least from minimum focus distance to infinity between the Z6 and Z6ii. The D850 is still faster in every test.
However, I have noticed in the field that the closer the system is to proper focus, the faster it'll drive the AF ring. So, if you start at minimum focus, it's not so great. However, if your subject is at 50 feet and you start at 30 feet, it latches on at speeds that seem comparable to DSLRs. The Z6ii also feels more confident with AF and is not subject to as much hunting and seems more accurate than the first model.
In short, while these results are a little disappointing (at least to me), keep in mind that most of the time we aren't racking the focus back and forth from minimum distance to infinity - and that sort of hunting happens far less with the Z6ii than it did with the Z6. Overall, I still like the AF much better in the new camera.