James Cameron's Avatar has a fine example with the first human installation that we see on Pandora, a pit mine in the middle of a beautiful bioluminescent forest. Later in the film, the destruction of the Hometree.
Armageddon The post-meteor shower shots of New York City
Blade Runner. Almost the de-facto example of Scenery Gorn, with dozens of slow camera pans depicting the Los Angeles megacity. But some would call it Scenery Porn instead.
Saving Private Ryan has Ramelle, a bombed-out town with a key strategic bridge, guarded by less than a platoon of paratroopers. It doesn't get any better when the film's final battle takes place in this town.
Doomsday has many scenes of a decayed and abandoned Glasgow in the aftermath of a plague.
Independence Day's multiple shots of ruined New York and Los Angeles after the alien attack. (Also other cities around the world, as much of an afterthought as this parenthesis.) The strongest of these was probably when Jasmine first emerges from the rubble and sees the ruins of Los Angeles, complete with poignant background music.
LOTR is made of Scenery Porn during the "good times" parts, and Scenery Gorn during the "struggling times" parts. You could make the argument that LOTR could be referred to as simply Cinemasturbation for its attention to detail in everything.
The best example is probably the view of the ruination of the Shire in the Mirror of Galadriel (the actual canon Scouring of the Shire was cut from the films, so this was Jackson's way of wedging it in). As Sam and Frodo say in the books, seeing your own home devastated when you remember it being pleasant is far more horrifying than some anonymous landscape that you never knew before it was ruined.
Film/Terminator managed Scenery Gorn without actually having the budget to have that much actual scenery.
The larger budget of Terminator 2: Judgment Day allowed for this combined with Desolation Shot in the opening scenes, complete with the classic "sea" of human skulls covering the ground, and the title sequence of a children's playground burning in the nuclear fires.
Parodied in Scary Movie 4 where Detroit is shown this way both before and after the alien invasion, the only difference being the latter having TriPods.
Parodied in Idiocracy - the cause of the destruction is not war of any sort, but the degenerating intelligence of the human race. Incomplete highways that people drive off anyway, buildings held together with duct tape, etc.
The Matrix films (particularly the first) certainly spent some time on the "desert of the real".
No Country for Old Men has plenty of this - from the barren, desolate Texas scenery to the long shots of dead bodies in the early stages of decay. Lesser directors might have actually shown the firefight between the dealers that Llewellyn stumbles upon. This would have been a mistake, as the audience likely would have found it to be exciting. Instead, all we see is the horrifying aftermath, and it is incredibly disturbing and effective.
To show the raging chaos Los Angeles is in at the start of Demolition Man, the Hollywood sign is on fire.
Sky Blue has numerous shots of the desolate world being pounded by a 100-year-old toxic rainfall.
2012's use of this was parodied even before it came out. The main characters say "Hey, come look at this!" often during the film just to show off the effects: LA crumbling and sliding into the sea, Hawaii, the Crack in Las Vegas, the tsunami coming over the... oh heck. It's two hours of Scenery Gorn. (The movie seems well aware of its purpose as such and dashes through the pseudo-explanation and character introduction with efficient haste to get to the show.)
Wristcutters: A Love Story is full of this. The movie takes place in an afterlife for people who commit suicide. It's pretty much barren wasteland with various heaps of trash strewn all over the place.
The Dollars Trilogy was famous for this. While the environments were very beautiful, they were almost always parched, dusty and deadly-looking. Even the farm at the beginning of The Good, the Bad and the Ugly is surrounded by miles of vast nothing.
Played for Laughs in Mars Attacks! - the Martians are shown taking great glee in creating this. Among other things, our heroes are awarded medals in front of the wrecked Capitol building.
The Element of Crime: In the grim darkness of post-World War II Germany, there are only ruins and flooded buildings.
Tarkovsky's S.T.A.L.K.E.R. spends nearly three hours alternating between this and plain old Scenery Porn. It goes from a nearly-abandoned and falling apart city to beautiful grasslands and then to a half dozen destroyed tanks in about ten minutes. That is lightning quick for a Tarkovsky movie.
Dagon's Imboca has seen better days, to put it mildly.
Dances with Wolves, when we see the buffalo that were killed just for the sake of killing them.
Transformers: Dark of the Moon does this with the Decepticon invasion and destruction of Chicago.
Battle: Los Angeles has numerous wide shots of the titular city, with burning buildings, heavy palls of smoke, and countless strewn bodies. Pretty much any wide shot in the first two minutes and after the first twenty minutes involves this.
In Toy Story 3, the dump, the conveyor belt, and the incinerator.
The original cut ending of Alien: Resurrection, restored in the special edition, has Ripley and Call sitting in a desert-like area of Earth filled with all kinds of debris. The final shot reveals that they're overlooking a thoroughly destroyed Paris, complete with the Eiffel Tower missing the top half and an orange-tinted cloudy sky (apocalypticly confirming an earlier throw-away line, "Earth... what a shithole.").
The Earth in WALL•E is weirdly both this and Scenery Porn: the trash-covered wasteland is both pretty depressing and awe-inspiring at the same time.
Inception has the dream city collapsing into the sea near the end.
In Coraline, after the title character finds the last MacGuffin, the world unravels in a truly surreal animation sequence.
Standard fare in The Book of Eli, though the major landmarks are fairly well off.
Patton starts with a battlefield complete with scavenger birds looking for meat and scavenger humans looking for uniforms and ration packs.
In Oblivion (2013) most of the Earth has been wrecked and we get lots of shots of crumbled, bombed, and/or partially buried landmarks (among them the Empire State Building, the New York Public Library, Brooklyn Bridge, the Pentagon (implied to have been ground zero for a nuclear strike during the Alien Invasion war) and Washington, DC).
You'll be hard pressed to find a Godzilla film that doesn't feature this in some form. Among the most notable examples are the crystals growing out of Fukuoka in Godzilla vs. Space Godzilla and the iconic shot of Godzilla emerging from the dust and rubble of several buildings in Godzilla (2014).