I meant to mention earlier but forgot.
Maybe have a look at close up filters. Just in case you haven't come across these, they are basically a magnifying glass which screws on to the filter thread of a lens. They often come in sets labelled, 1, 2, 3, 4. My most uses one is a No.4. They're not as good as a macro lens but they are useful for close up shots when you're out and spot something but haven't got a macro lens with you. I have a set that cost under £30 maybe 30 years ago

These days they start at under £10.
Another thing to possibly think about is a film era manual focus macro lens. As macro is normally done with manual focus the manual focus only nature of these lenses shouldn't be an issue. I have an old Sigma 50mm f2.8 macro which is 1:1. You use these in either manual or aperture mode via a cheap adapter. One advantage of these manual film era lenses is that they're cheap. I've taken a lot of pictures with this Sigma and other cheap film era lenses.
Good luck with this. have fun!