For example:
The crosswalk on Abbey Road from the Abbey Road album cover.
The steps of the Philadelphia Museum of the Arts from Rocky.
Various places in Dublin, in James Joyce’s Ulysses.
The bridge over Tokyo Bay, as destroyed by Godzilla.
The “Goonies” house in Astoria Oregon.
Those poor people.
I was looking for a place to eat on Apple maps while driving through Studio City and saw a marker for The Brady Bunch House. Out of curiosity, I headed that way, but got diverted by a dim sum place on Ventura Blvd. Apparently, you can rent that house for $12,500 a month.
I recently drove through Forks, Washington for the first time, and it was probably the most unimpressive thing on the entire peninsula. But there were still remnants of Twilight fandom around.
Hazard, Nebraska, because of the song by Richard Marx.
55 Central Park West in Manhattan, a.k.a. “Spook Central” from Ghostbusters.
I went to Tom’s Restaurant in New York City, once. It’s doubly famous; was the exterior used for Monk’s Cafe in Seinfeld, and the inspiration for Tom’s Diner by Suzanne Vega. I also spotted it in the background of a scene on Law & Order.
Dinah’s restaurant in Culver City (pancakes and fried chicken) was the restaurant where the nihilists in The Big Lebowski ordered their pigs in a blanket. It was also in a Zippy the Pinhead cartoon.
As an aside, I saw Carrot Top there once years ago, but had no idea who he was until someone asked for an autograph and I asked the guy who it was.
The “blue house” from Lady Bird, on 44th Street in Sacramento. Apparently when the owners agreed to let Greta Gerwig film there, they though “Oh, it’s just some small indie film that not many people are going to see.” Then when the movie actually became popular there was a steady stream of people taking selfies in front of their house.
And there’s this place, an ordinary house that is now an actual tourist attraction.
The Home Alone house in Winnetka, Illinois.
For that matter, half the frickin’ North Shore is now a tourist destination thanks to the late John Hughes.
Arguable whether its “been made famous by” as its been used as a location for various other things previously, but Highclere Castle (in my home town, or near it) is definitely most famous nowdays as “Downton Abbey” from the eponymous TV show:
Lots of stuff to choose from in San Francisco, but the one that always stood out to me (as it literally stands out as you cross the bay) is the Naval Headquarters building that became a Zeppelin hanger in Indiana Jones:
I used to live around the corner from the “Full House house”, but they were famous as The Painted Ladies long before they were in the credits of Full House:
Bourbon Street. You don’t even need to mention the city, everyone knows.
Mentioning San Francisco made me think of the Full House house, before I even read the second paragraph of your post.
There’s a shitty looking pawn shop in Vegas with a line around the corner of people waiting to get in.
Oh in London there is Battersea power station is arguably famous as the backdrop to Full Metal Jacket. Its arguable as the whole point is Kubrick spent an enormous amount of effort to make it NOT recognizable as somewhere other than Hue, Vietnam.
Also famous for non-film reasons for the Pink Floyd album cover and the related escaped pig incident: