I recently purchased a Nikon Z5 mirrorless camera and am interested in getting into macro photography. I mainly shoot flowers, insects, and other small subjects like jewelry or textures. I want to capture impressive details and magnification.

Can anyone recommend a great macro lens that would work well with my Nikon Z5? I'm willing to spend around $500-800 for a lens. I know Nikon makes a Z MC 105mm 2.8 VR S macro lens but that is over my budget. I could possibly stretch for it if you feel it would be that much better than third party options.