It depends on what you want from the camera.
We have a Fuji Finepix that cost around $150 and the results are generally OK.
This is a close up of a terminal strip. It's clear enough but there is some spherical abberation. But it does the job.
Same with this:
But to appreciate the difference between that and a fairly good camera (and I apologise for the personal indulgence) here is the Fuji rendition of one of our little lot:
And the Minolta of another of them:
The first is fine and shows a happy little girl - plus all the background clutter.
The second is just the subject.