Why are DNG, NEF or other raw photos look such different at first sight, no editing, as D-LOG, ProRes and other raw or near to raw video frames?
Photos look contrasted while videos look flat.
By "look" I mean the preview on a Mac OS.
The word "RAW" means different things in your question.
DNG, NEF, CR2 and other RAW photo file formats contain raw data which needs to be interpreted by a RAW file viewer before you can see an image on a screen (e.g. with Preview on Mac OS). This interpretation can happen in infinite ways resulting in images that look (slightly) different. This answer goes through the interpretation steps.
The D-LOG video you refer to as "RAW", is already an interpretation of the actual raw data from the camera sensor. It's an interpretation which leaves you a lot of room to work with in terms of color correction, but it's still an interpretation. This article goes into more detail.