Camera body do and will play a part in the photo taken, that is a fact I cannot dispute. However what really matter is the techniques and skills involved.
In macro photography there is a couple of things that are important
1) Skills, techniques
2) Lighting
3) lens
First and foremost is the correct techniques - such as how to hold your lens, how to compose for picture, how to keep a stabilise your camera, etc, etc. Secondly, control of lighting - this can be accomplish using external flashes (or even built in flash of the camera if you know how). And then it was the lens (dedicated macro lens - it came in many variety, such as the very popular 105mm Nikkor lens, 180mm, 90mm, 150mm, etc)
There is a big section in this forum that is dedicated to macro techniques and equipment uses.
Finally, like I previously replied to another of TS thread, any DSLR can take great macro shots - hack, even a entry level DSLR or even a point and shoot can take good macro shots. It is the skills and techniques and effort behind the camera that counts most.