1. Sony FE 90mm f/2.8 Macro G OSS: This is a highly regarded macro lens from Sony, known for its excellent image quality, sharpness, and bokeh. It features Optical SteadyShot (OSS) for image stabilization and a fast, quiet autofocus system. While it's one of the more expensive options, it's a top-performing lens for serious macro work.

2. Sigma 105mm f/2.8 DG DN Macro Art: The Sigma 105mm f/2.8 is a highly capable macro lens that offers excellent sharpness, color rendering, and build quality. It's a relatively new addition to Sigma's Art series designed specifically for mirrorless cameras. It's slightly more affordable than the Sony 90mm and delivers impressive results.

3. Sony FE 50mm f/2.8 Macro: If you're looking for a more compact and affordable option, the Sony FE 50mm f/2.8 Macro is worth considering. While it has a shorter focal length, it still provides a 1:1 magnification ratio and delivers sharp images. It's a lightweight lens that's easy to carry around for casual macro photography.

4. Tamron 90mm f/2.8 Di III VXD Macro: Tamron recently released this macro lens specifically for Sony E-mount cameras. It offers excellent image quality, fast and precise autofocus, and weather-sealed construction. It's a solid alternative to the Sony 90mm macro lens at a slightly lower price point.

5. Laowa 65mm f/2.8 2x Ultra Macro APO: If you want to explore even higher magnification ratios, the Laowa 65mm f/2.8 2x Ultra Macro APO is a manual focus lens that offers 2:1 magnification. It's known for its exceptional sharpness and unique perspective. However, being a manual focus lens, it may have a steeper learning curve.

Ultimately, the best lens for you will depend on your specific needs, preferences, and budget. The Sony FE 90mm f/2.8 Macro G OSS and the Sigma 105mm f/2.8 DG DN Macro Art are both excellent choices that offer top-notch image quality and performance. If you have the opportunity, it's always a good idea to rent or try out the lenses before making a purchase to see which one suits your style and requirements best.

I'd prefer a lens that offers a good balance between image quality, autofocus performance, and value for money. I'm open to both Sony and third-party lens options.

Some lenses I've been considering are the Sony FE 90mm f/2.8 Macro G OSS and the Sigma 105mm f/2.8 DG DN Macro Art. However, I'd love to hear your thoughts and experiences with these lenses or any other macro lenses you recommend for the Sony E-mount system.