Currently there are 9 native Macro Prime lenses for Nikon Z6 III and 4 of these lenses are autofocus (AF) type.
Z6 Mark III also has a sensor based image stabilization system which means that all of these lenses will be stabilized when used on Z6 Mark III.
Since Nikon Z6 III has environmental sealings (Weather Sealing), you may like to couple your camera with one of these 4 Macro Prime lenses with Weather Sealings.