It really depends upon what size cameras you are wanting.
The better ultra compact (thin) cameras tend to cost more than $200.
The slightly larger compact (1.5 inches thick) cameras offer some very good cameras for under $200.
Probably one of the best in that price range is the Canon A570.
It can be found for about $175.
For a little less, there is the Canon A550 and A560.
If you want more zoom, look at the slightly larger, highly rated Fujifilm S700/S5700.
It sells for $200 and offers a lot of camera for the money.
Just about all digital camera do a good job with macros.
The secret to good macro is to use something to steady the camera.
A tripod is best.
And a lot of light helps.
Any camera with some manual controls is even better, so that you can control depth of field.
That would be the Canon A570 and the Fujifilm S700/S5700.
My uncle is going to buy a new camera but I really don't know which one he should get. Can someone recommend a good one for less than $200. I'd like to get one that's good a taking macro pictures.