You can visit the location that the cover for Crowbar's Sonic Excess In Its Purest Form was taken in New Orleans, Louisiana. The park containing the statue featured on the album cover is located behind St. Louis Cathedral: https://musicmap.place/pin/d33e807b-0536-4b40-a439-acef327c7d3b
While the band hails from Philly, the cover for their (hopefully not) last album was taken in Salt Lake City, of all places, and you can visit the location yourself. If you go, try to visit on a clear day so the mountains are visible in the background. Is this the most famous album cover taken in Utah? Have you been to the spot/recreated the cover photo?
The Killers' Pressure Machine album cover photo was taken from the barbed wire fence of First Baptist Church in Nephi, Utah.
I believe the original image was a stock photo that was edited to make the final cover. It turns out this is a popular location and well-loved by photographers who go out of their way to get a shot of the abandoned location.
Link to location: Lil Peep - Goth Angel Sinner
The cover photo for Hum's 2020 surprise return album, Inlet, was taken at Rainbow Bridge National Monument, in Utah.
Link to location: Hum - Inlet (Album Cover Location)
Went for a holiday driving around Scotland a few years ago; did a bit of research and managed to find the water tower that’s on the cover of Mogwai’s EP+6 compilation (seen more clearly on the vinyl reissue entitled EPx3).
From what I've seen online, the photograph was taken by William Eggleston and described as being taken "near Greenville, MS, in the American south".