Tons of options out there from Nikon, Canon right through to Sony and Pentax.
Currently, the best macro lens is the MP-E65 manual focus lens by Canon. Nothing to touch it and its not a lot of dollars for what it is.
I would suggest mirrorless, EOS RP with the MP-E65 or 100mm F2.8 L IS - an alternative is the 180mm offerings.
I would also recommend getting a macro rail as trying to achieve focus with a very narrow band depth of field can be very frustrating.
Lighting, as has been mentioned, is even more important. Have all the fancy kit but when you're quite close to the subject/object your camera blocks most of the light.
Ring flashes or the double head macro flashes work very well but can make the whole experience quite pricey.
If you're on a really tight budget, use extension rings with a good prime lens rather than a zoom.
Look here for an example of what the MP-E65 can do - mind blowing macro stuff of some really cool little guys
Bookmarks