It's unreliable to generalise but my experience is that even quite cheap cameras from Olympus really excel at macro pictures, though a great deal of the success is often to do with adequate lighting as mentioned in previous posts above.
I actually use a Panasonic FMZ20 12X Zoom model and have by no means got the hang of it!
Without the slightest pretence of decent lighting, I popped off some quick pics of my N Gauge Rheingold coaches when they arrived, still in the box. The following series of pics are all versions of exactly the SAME shot taken at about 12 inches range with NO zoom employed. This camera takes 5 Mpixels shots which enables severe cropping while maintaining high resolution - a different way to get up close. The only treatment utilised was to shrink the first two to 25% of original resolution to fit onto the page here, the third one shrunk to 50% and the fourth is actual size as taken. Please excuse the filaments of white fluff, so obvious in the pics but which were not actually visible to my naked eye before taking them!
1. Original image - no manipulation. Although 'shrunk' to 25% of original file size, this is still around 4 times bigger than the actual model.
2. Same pic cropped a bit
3. Same pic, cropped a bit more
4. Same pic cropped right down to approximately 40mm from side to side
Remember, this is N Gauge - the subject is tiny and normal eyesight cannot read that print! If anyone disbelieves me, try to read the same print in the first picture and remember that even that one is around 4 times bigger than the actual subject.