I would say the sky and a private eye's dimly lit, smoke-filled 1920s office are pretty different, actually.
It's common for games to have an intentional designed aesthetic which uses cultural and social and graphical "languages" to create specific emotional impacts and effects. The lower the budget the more this is leaned into for expedient reasons but that in turn creates genre expectations! Low-poly and 8-bit are fine examples of what were once a product of technical limitations becoming their own target.
Subject matters also, and the overall aesthetic of the game; triple-A games often push towards what you're describing, that the most impactful and compelling may also be the most real...
...or at least, contain elements of it. Lots of games mess with color shading and saturation etc for the impact-reasons...
I do look forward to the era of more "photorealistic" rendering as you prefer, especially for natural landscapes like those I enjoy IRL. Some of which can have very "unnatural" feeling swings in tone and all sorts of things! I was just up in the mountains this week and saw a lot more variation in lighting and its impact on a consistent landscape (mountains across a lake) than I've ever seen in a game engine so far :)
And before games this was true of movies and before that photos and paintings. A master cinematographer can spend hours lighting a shot that will later be praised for its 'gritty realism' :-).
By extension, this means that it is highly desirable to have a renderer capable of reproducing the real world as a baseline for highly controllable aesthetic tweaks. When you look especially at VFX specific tools, they have - almost without exception - two layers of tools: the first creates a realistic simulation (e.g. water/fire/shattering...) and the second layer allows for tweaks to control the final look.
I think a Horizon Zero Dawn developer characterized their approach as “more realistic than reality” or something along those lines, i.e. they were aiming for the kind of perfect saturated look that you would only get in that golden hour with ideal surroundings but that we all recognize as real and at the same time don’t find too dull to stare at for hours. And I think for daytime HZD did do that quite well.
Likewise, Ansel Adams is particularly famous for popularizing manipulation of exposure, both in-camera snd during development.