Essentially you want a lens with its own autofocus motor. That means AF-S or AF-P lenses. Plain AF or AF-I will not work; the first because of requiring a focus motor in the camera body, the second because of electric incompatibilities. You'll often see lenses specified as AF-D: that is not a terminology that Nikon uses itself. It means a plain AF lens requiring a motor in the camera body, but delivering distance information to the camera body. Nikon specifies the distance info by appending a D to the aperture info, like "AF Nikkor 80-200mm 1:2.8D" but other people like to call it AF-D. Same problem as with normal AF lenses.

Instead of the "D" there can also be a "G" which means the same, but it also means that the lens has no aperture ring for setting aperture manually instead of through the camera body. The presence of the "D" or "G" itself does not mean you have no motor; the absence of "AF-S" or "AF-P" is essential. Since every lens of "AF-S" type or later has the distance info, "G" or "D" have been left out of the lens name at some point of time.

The FTZ adapter contains no optical elements which means it does not impact image quality. It translates the digital communication to the lens and provides the lens with the distance to the sensor it is designed for.

That distance is larger for the Nikon F mount than for the newer Nikon Z mount used for mirrorless cameras. The smaller distance of the latter makes life for the lens designers easier, so with lenses designed with similar effort and competence, the "native" Z mount lens has a chance to be optically superior and/or more compact. In practice, this does not really appear to be much of a game-changer.