It depends on the quality of the camera lens. From my experience, the more expensive a camera is, the more accurately it captures real appearance.
Cheap cameras have a higher range of parabolic effect. This means, the curvature of the lens distorts the image it is photographing.
If you take a picture of a two dimensional square object, like a tile or a card with less than two feet of distance in between, most cameras will very slightly bulge the center of the image out causing a minute amount of curvature to the object that is normally not there when viewed in reality.
This is also called the “fish bowl” effect.