The best holes I've ever seen are the single hole electron microscope grids I used in a variety of transmission electron microscopes. These apertures are made by etching and are close to perfect at a molecular level.

The sharpest looking pinhole pictures tend to exploit high contrast high frequency detail that is just coarser than the limiting resolution of the pinhole itself.