I love my 24-200. Lightweight, flexible, small and easy to handle, I've had mine for nearly two years. It can take on macro (auto focus stacking!), landscape, wildlife, sports with ease, this little package is very capable. If it delivers unsharp images, it's my fault, not the Nikon's.
Subjective DOF characteristics aside, the relatively slow aperture is not as important as you might think, given the high ISO performance of the Z6ii.
All the usual VR and AF systems work well with this lens in still pix work. Not so much in video.
The Z6ii is a good companion with the 24-200 for stills work. They make a compact, lightweight, high quality travel and walk-around package for stills.
The 24-200 is an excellent video lens, but the Z6ii is a terrible video camera for usability reasons. Under the right conditions, it can produce good video imagery. It's just very uncooperative to use.
24-200 lens and Z6ii highly recommended for stills. Not for video.