And, between the song, its depiction in The Grapes of Wrath, and the 1960s TV series, it became a cultural icon.
As does Holsten’s the place where the infamous final scene of the series was shot.
I was trying to think of anything otherwise unremarkable in the DC metro (where I currently live) and couldn’t think of anything. There is the national mall, of course, but thats hardly unremarkable.
I somehow got the idea that William Forest Park, next to Quantico Virginia was the setting for the opening jogging scene in Silence of the Lambs, but IMDB tells me that is not the case:
The actual events of Exorcist (well some version of them) took place in Mount Rainer (near where I first lived in the DC metro), not really famous for it though (and there is debate as to exactly where the events took place):
They do trade on the name, but the prime location at the junction of Skyline Drive and Hwy 84 has a lot to do with the restaurant’s success. It’s the perfect place to stop for a bite to eat for folks out on day trip (especially bikers), and they do have decent food. The place would still be packed on the weekend without the Arlo Guthrie connection
I used to live in Hoboken, NJ, and on weekends the store that housed the Cake Boss always had a long line around the block. It was kind of annoying.
Also “On the Waterfront” was filmed in Hoboken. There were several locations in town that were used in the movie that are still around. Not really tourist destinations these days, though.
The Mary Tyler Moore house was a tourist attraction in Minneapolis for many years.
It also made a brief appearance in the video for Dream Academy’s “Life In A Northern Town”.
But how was your hair?
Huh! I remember it most from the Mission: Impossible two-parter where the bad guys had an underground missile factory. Never in a million years would I have recognized it as the entrance to the Batcave! 
The IMF blew up the factory by jiggling the clearly labeled “FÜEL MIX.”
There’s a certain streetcorner in Winslow, AZ…
There are also some street crossings that are claimed to be the place in “Crossroad Blues” where Robert Johnson made a deal with the devil.
Not sure it was made famous, but University of Oregon in Eugene was the location where they filmed Animal House.
Can you see this picture without hearing the music?
“Forrest Gump Point”
A bakery in Washington DC called Georgetown Cupcake was featured on a reality television program about ten years ago. As a result, it became very popular and there were often long lines to buy their cupcakes. People I know who tried them say they were fine, but not worth waiting in a long queue.
As I recall, Anthony Bourdain said that he sometimes purposely didn’t say exactly where some of the places he went to on his show were, because he didn’t want them to become overrun with tourists like that.
The Dibble House in Eldon Iowa.
This house was used as the background in the Grant Wood painting, American Gothic. It’s currently a tourist attraction, open for business Wednesday through Sunday.
The Billy Goat Tavern. Cheezborger! Cheezborger! Cheezborger!
Reminds me of this place:
Certifiably batshit crazy! 
Here’s a story about Gram Parsons’ death from one of my favorite YouTubers.
