I have used olympus uz (3.2mp) & sony DSC HX1 (9mp) and find both give fair results for semi macros of stones & broaches, and suspect that most in the upper end of that range will do so quite well.