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