I needed to quickly digitize several 35mm transparencies this week and used my 60mm AFS with the FTZ and it worked just fine. Fast and easy and the image quality on the Z6 was quite surprising. Normally, I'd run the scanner but didn't want to take the time for since most of the images were going to be reproduced as 5x7 at the most. IMO, the files are probably or nearly as good as a good scan with a lot less effort.
Generally in the field I'll use a Nikon 5T or 6T on my 24-200 or 70-200 AFS/FTZ and be done with it. Much more convenient than using tubes or a real macro lens since seldom do I need flat-field when I'm out in nature and it's nice to be able to change the framing without having to contort the tripod nor my body.