The Sony 30 macro is a good choice as a 'general purpose' lens for Sony A6xxx cameras. It is cheap to buy new, or you could find a used one, try it out, and resell it if you don't like it, without losing much money.
As others have said, working distance is very short once you get into true macro territory. However, lighting is not too difficult even then, with small strobes. It was my "go to" lens when I first migrated from FF (Nik D800E) to APSC (A6500, now A6400), with 2 x Inon S2000 strobes.
The main problem with this lens is that if you like shooting small active subjects (e.g. gobies) as I do, you will be well inside their comfort zone by the time you get close enough for a decent pic. Which means endless stalking, or waiting ages for that one individual braver than the rest! For fish 100mm and over, no problem.
I don't use my 30mm so much now, as I've split my "go to" lenses these days into two: a Sony/Zeiss 24mm behind a mini dome for general purpose stuff, or a Zeiss Touit 50mm macro for most macro (and general purpose if the viz is OK). Both of these perform their respective tasks brilliantly, but are expensive, so def. worth looking for good used examples (I bought mine from Japanese resellers on ebay).
Two caveats with the Zeiss Touit 50: check that it has version 2 of the firmware installed. While this is a free upgrade which can only be done by selected Zeiss agents, it will take a month or so...
And preferably only use it with the later A6xxx cameras, i.e. A6400 or A6600. The AF is slow with earlier bodies and significantly better with the later ones. The AF improvement was the reason I upgraded from A6500 to A6400 (unfortunately that also required a change of housing...)
I like the Touit 50 so much that if I ever "upgraded" to FF Sony (unlikely, but never say never...), I would keep it to use in crop mode, noting that its AF would be even better with the latest fancy pants FF Sonys.