Camera with no focus will have no blur with anything from 50 cm. So you can't take any macro pict without an additional lens. But, there are few advantages : a smaller camera module with no mechanical parts at all, no need to focus so almost the whole picture will have no blur, and so the camera shutter is faster, you will have less blur movment than with a classical camera.
Between both kind of camera (with and without focus), there isn't really one which is better, it's only different way to take pictures.