I mention this fact in every workshop and program I run that you can buy an entry level lowest price DSLR or mirrorless camera and produce excellent macro images.
In 2004, almost 20 years ago I bought my first digital DSLR camera. Here it is a Fuji Finepix S2.
This camera which was only 6 megapixel and generations ago in the age of the digital cameras had produced my most successful image of all time. The image was shot in Yosemite and is a fern on a burned tree trunk that was lying on the ground.
The image was published in Outdoor Photographer magazine in three issues, plus published in other photo mags, won highly honored in the Windland Smith Rice International photo contest by Nature's Best mag, won second place image of the year in the flora category at Naturephotographers.net, and the rights to the image for all advertising was purchased by Hewlett Packard.
It has accomplished more than any other image I have ever shot, and it was done with a camera that doesn't compare to the cheapest DSLR camera sold today.
So, I always preach that whatever camera you own whether it be a DSLR, mirrorless, or even your phone, will produce great macro images.
It's more about finding great subjects, composing them well, and doing some good post processing, any camera can do a great job producing the image, as long as you know how to work the camera.
Both my latest camera bodies, a Nikon D7500 and Fuji X-T30 MKll, sell for under $1,000.
Here is that Fern on Burn image.