Buy the smaller sensor. Look for 20 to 36 megapixels. Check the weather sealing. Then find out what lenses the system actually offers, before you spend a cent on a body.
That order surprises people. It shouldn't. Macro photography asks very little of a camera and quite a lot of everything else, and the specs that sell flagship bodies turn out to be close to useless once you're down among the beetles.
The Flagship Specs That Do Nothing for Macro Photography
The Sony a9 III shoots at 1/80,000 of a second. It costs around $6,000. The Sony a6700 costs $1,398 and stops at 1/8000. For macro work the cheaper camera has the edge, and not by a small margin and that's because high shutter speeds are of little importance to macro photography.

ISO ceilings tell the same story. Canon's EOS R1 reaches ISO 102,400 natively, expandable to 409,600. Impressive number. Useless to us. You're shooting with flash, you control every photon that lands on the subject, and you never need to climb very far off the bottom rung. Most macro photos are shot at ISO100 or 200.
Why Macro Photography Lives at Base ISO
Depth of field at life size is measured in millimetres. We stop down to f/11 or further to claw some of it back, and that shuts out most of the light. A close focusing lens collects very little to start with. So we add flash.

Straight out of the box that flash is harsh and directional. A macro diffuser sits between the flash and your subject, spreading the light and randomising the direction of the rays. The light arrives soft and even. Shadows lift, highlights stop blowing out, and fine detail survives instead of getting cooked.
Sensor Size Is the Real Macro Photography Decision
Three sizes matter here: Micro Four Thirds, APS-C, and full frame. Ignore medium format unless you own a Hasselblad and a very forgiving accountant.
Bigger sensors hold more pixels, and bigger ones. Each photosite has more surface area to collect light, which renders marginally sharper files. Only a trained eye ever spots the difference. Search around online and you'll find people insisting full frame is the only serious option. For macro that's simply wrong.
Small Sensors Solve the Depth of Field Problem
Put a 90mm macro lens on a full frame body and you get beautiful working distance and a plane of focus about as thick as a hair. You need that working distance, because flies and jumping spiders and shy lizards don't negotiate.

Now put the same lens on APS-C or Micro Four Thirds. The field of view crops in, so you fill the frame with the same insect from further back, at lower magnification. Depth of field opens up into something you can actually work with. You keep the working distance and lose the misery.
Smaller sensors are also much cheaper to make, and that saving lands straight in your pocket. Fewer missed shots, faster focus acquisition, smaller bill. For skittish subjects in the field, that's the whole argument.
When Full Frame Still Makes Sense
Shooting still life? Photographing pinned specimens, flowers indoors, anything that holds still? Full frame is a fine choice. Focus stacking compensates for the shallow depth of field, and you get every last drop of image quality. The moment your subject can walk away, the maths flips.
Weather Sealing Is Worth Paying Real Money For
I've destroyed two camera bodies in the field. Rain both times. It was every bit as expensive as it sounds.
OM System sets the standard here. The OM-1 carries an IP53 rating under the IEC 60529 ingress protection standard, and it's the only interchangeable lens camera rated that way. That's a published, tested figure rather than a marketing promise about being "environmentally sealed." Nikon appears to have done something right too, based on years of user reports. Canon and Sony build excellent cameras, but they don't publish IP figures.

Check the Macro Photography Lens Range Before You Buy the Body
Every major brand offers a standard macro lens in the 90 to 105mm range. That part is settled. It's the specialised work where systems pull apart.
Wide Angle Macro Lens Options Differ Wildly by System
Wide angle macro shows a small animal inside its habitat, and it's one of the most rewarding things you can do with a close focusing lens. Native options are thin on the ground.
OM System has the M.Zuiko 12-45mm f/4 PRO. It focuses to 12cm and delivers 0.25x magnification across the whole zoom range, which is 0.5x in full frame terms. Weather sealed too.

Canon's EF 8-15mm f/4L Fisheye focuses to 0.15m and reaches 0.34x at 15mm. It's an older EF lens, so RF bodies need the adapter, and the results want a bit of cropping. Still very usable.
Nikon Z and Sony E have no native close focusing wide angle worth recommending. Venus Optics fills that gap. The Laowa 15mm f/4.5 0.5x Wide Angle Macro sells for $399 and comes in Sony E, Nikon Z and Canon RF. The older Laowa 15mm f/4 hits true 1:1 but ships only in Canon EF, Nikon F, Sony FE, Sony A, Pentax K and Leica L. It's fully manual with an aperture ring, so it adapts onto any mirrorless body you like.
Megapixels: Enough to Crop, Not So Many You Lose Sharpness
This one matters more than most people expect. Nearly every tight portrait of an insect's eye you've admired was cropped in post. Low resolution older bodies take that option away from you.
Push too far the other way and sharpness starts falling off. For full frame, 24 to 36 megapixels is the sweet spot. For Micro Four Thirds, around 20.

Where Your Money Actually Goes Furthest
Macro is one of the few genres where a modest budget costs you almost nothing. You don't need blistering shutter speeds. You don't need a monstrous ISO range. You need a sensible sensor, enough resolution to crop, and glass that suits the work.
What you do need is control of your light. The camera records what the light does, and harsh direct flash will ruin a technically perfect frame every time. That's the problem we built the ProMacro Custom Diffuser to solve, shaped to your exact body, lens and flash so no gaps let raw light through.
Learn to read light and handle your camera properly, and a $1,400 body will beat a $6,000 one in the wrong hands. Want to work on that hands-on? Come and shoot with us at ProMacro Atelier.