I'm pretty satisfied with my homemade pinhole cameras, but each year I look through the new crop of pinhole shots from Worldwide Pinhole Photography Day (I participate) and I've noticed a surprising percentage of shots that really grab my eye as to quality and sharpness turn out to be taken with Zero Image cameras. They must do a well crafted build of a well optimized design.
Of course some folks like the mushy, shadowy, light leaky and irregular results from crude pinhole cameras, so the definition of "good" can vary a lot.