Probably something closest to what your eye sees is ideal for most photos. But dumb optical cameras have all kinds of artefacts that eyes don’t. When I slightly bump the camera, the whole image comes out blurry, my eyes don’t do that.
Things like lens flares don’t exist either.