The only director who laboriously follows through on 'I want it to not look like CGI' is Christopher Nolan. Others seem to favor stylized beauty over absolute CGI realism.
There are several, several youtube videos showcasing the incredible work of studios like Industrial Light and Magic creating most of the backdrops you thought were shot on location.