As an addition to that, when Iused to shoot macros on my bridge cameras namely the Canon SX series from about 5yrs ago I used to use a macro lens attachment.
The Raynox DCR-250 is about £50 from Amazon and allows really close manual focussing and can be clipped onto the front of any lens with upto a 58mm thread. That said, I used it on my 17-85mm with 67mm thread and just taped it in place. The vignetting didn't bother me as most macros get cropped in anyway.
Might be another option for you before spending out on very specific use lenses