I don't have a Nikon, but in general it sounds like you want a macro lens.

This isn't really how lenses work. They have a specific lens mount, a focal length, a speed (amount of light that they can let through the aperture), measurable contrast, measurable color accuracy, and a measurable degree of sharpness.

Some modern lenses also have auto focus, vibration reduction, and other advanced features.

What are you actually trying to do? Most likely, you need to figure out the focal length and speed that you need and buy the appropriate lens that fits the lens mount that you have.

I would appreciate recommendations for a Nikkor that catches food and plants details without fussing. It would tremendously help if it’s compatible with the Nikon 6 II body.