I noticed the earlier response regarding the vintage Tamron SP 90mm f/2.5 Macro lens and second that recommendation. This is a manual focus, manual aperture Adaptall2 lens... designed to utilize interchangeable mounts, which are easily swapped out and available to fit virtually any DLSR or mirrorless system. I checked to see if an Adapall2 is available for Sony E-mount and found several, including:
https://www.amazon.com/Fotodiox-Lens-Mount-Adapter-Mount/dp/B0054EORIIhttps://www.amazon.com/Fotasy-Adaptall-NEX-VG900-NEX-FS100-NEX-FS700/dp/B00L6BZE5SI have used several copies of the Tamron 90mm Macro lenses over they years, and still have Adaptall2 mounts that allow me to use them on six or eight different vintage and modern camera systems (incl. Canon FD, Konica K/AR, Pentax P/K, Nikon F, Canon EOS/EF and more). Adaptall2 mounts are relatively simple and, as you will see at the above links, much less expensive that the fancier Metabones, etc. designed to use more modern autofocus, electronically controlled lenses. The lenses themselves are pretty easily found selling used at bargain prices.
The 90mm f/2.5 is a 1:2 lens on it's own, but sold originally with matched 2X teleconverter that fits between the Adaptall2 mount and the lens body to make it full 1:1 (but also a more difficult to hold steady 180mm, also with much shallower depth of field at any given aperture). Instead of using that, I simply use standard macro extension tubes of various lengths to increase the lens' magnification, when needed. For example, I added a 20mm macro extension tube to mine to make the following images at somewhat higher than 1:2 magnification:
For comparison, the following is another shot of the poppy buds above, except it was done at 1:2, without any macro extension, using the lens alone:
All the above were shot at f/11 with the lens mounted on one of my Canon 7D cameras using an EOS/EF Adaptall2 (installed on the lens shown below, in left hand image, with a Nikon F Adaptall2 mount shown alongside).
The right hand image above shows the relatively compact Tamron 90mm alongside other macro/closeup lenses I use (Canon EF 100mm f/2.8 USM, EF 180mm f/3.5L USM, and TS-E 45mm f/2.8 Tilt Shift). The best part... it's by far the least expensive of any of the lenses shown. I bought this Tamron SP 90mm f/2.5 Macro lens used at a local secondhand store for all of $20, in like new condition including caps, hood, the matching 2X and with a Nikon F mount installed. I spent another $40 to get a "chipped" EOS/EF Adaptall2 sent from China (on Canon cameras, the chipped mounts and adapters allow Focus Confirmation to work). $60 total for a macro lens! Not bad, IMO.
There were four versions of the Tamron SP 90mm f/2.5 Macro lens... Original model 52B from the early 1980s shown above is all metal, even the grip of the focus ring (hood is rigid plastic, bayonet mount). Optically identical I think, model 52BB was introduced in 1988 and can be most easily distinguished from the earlier model by it's checkered, rubberized focus ring. (Models 52E from 1990 and model 152E from 1994 appear to be early autofocus models, which will have non-interchangeable mounts.)
In 1996 a Tamron SP 90mm f/2.8 Macro Adaptall 2 lens (model 72B) superseded the earlier f/2.5 models. It's also a good, manual focus, interchangeable mount lens. It is able to do 1:1 all on it's own, without any added extensions or converters. In fact I think this lens is the basis of the more modern and current autofocus lenses. I also think some variant of the Adaptall mount version (B57-100?) may have remained in production until fairly recently (seems more plasticky than the earlier models).
If you prefer, I see that Samyang/Rokinon offer a 100mm f/2.8 in Sony E-mount... a manual focus/manual aperture design. It gives full 1:1 and is internal focusing (doesn't increase in size when focused closer, the way the Tamron 90mm and some other macro lenses do). Cost is about half that of other 100mm macro lenses in E-mount... about $550 in either Rokinon or Samyang version (it's the same lens). No adapter needed... this lens is designed for E-mount. Note: The Samyang/Rokinon is a rather heavy lens, which might be a bit challenging to use with a tripod or monopod while mounted on a relatively small, light Sony E-mount camera. I read somewhere that someone had found one of the tripod mounting rings for a Canon lens will fit and worked with it (but am not sure which one). I'm sure that helps a lot (in fact, one of the top reasons I like the Canon 100mm macro lenses is that they can optionally be fitted with a tripod ring). The optional/replacement Canon OEM tripod mounting rings are rather pricey (around $150)... but there are third party, Chinese-made clones that cost about 2/3 less: $50 (metal ones... avoid the even cheaper plastic ones, ~@25). If you want to try this, you'll have to research which ring fits the Samyang/Rokinon lens.
Manual focus really isn't a big deal when shooting macro. In fact it's often preferable to autofocus, which I sometimes turn off on my macro lenses that have it. Manual aperture control may be a bit slower... But on my Canon, if I wish I can still get auto exposure using aperture priority mode or by enabling Auto ISO in manual exposure mode. (I just can't use shutter priority or program AE modes with a manual aperture lens such as this.) I imagine it's similar on Sony. Presetting a smaller aperture manually does dim down the image in an optical viewfinder such as my Canon DSLRs use. That can make manual focusing a bit trickier and really small apertures may cause Focus Confirmation to struggle or fail, particularly if shooting in low light conditions. But I believe your Sony uses an electronic viewfinder, which may be able to overcome these relatively minor inconveniences. On my Canon I can use Live View with Exposure Simulation to help a lot in those situations.