Depends on your skill level
I use a little Fuji Finepix Z1...works great and has a really good macro. You can definitely get better, but I was a professional photographer for many years, and I do not want to handle the bigger cameras anymore (you would be surprised how heavy a 35mm w/professional flash can become after 3-4 hours strapped around your neck, let alone a Hasselblad).
Lighting is the biggest factor. I like to use the natural light on my deck...it is simple, etc, but even then, harsh light (too bright direct sun) can create hard shadows, etc.
You would be very satisfied with a Nikon, Canon or Fuji professional grade camera, if you want to spend the money, but a nice little 5-7mb resolution with a good size memory card will work just fine. I knew the Fuji folks professionally for many uears, and learned to trust/like their products.
Joe