Natchitoches Louisiana had an upsurge after Steel Magnolias, especially the Christmas Festival. http://http://www.natchitoches.com/
Portland has gained some attention because of TV shows like Grimm, Leverage and Portlandia.
??
Monument Valley has been the background in virtually every movie or TV western.
Apparently it’s called Mugu Rock.
ETA: Here’s another link showing how the “rock” was created.
Rhymes with luge.
Good pick. The reality of the place is pretty cool, too.
The basement at the Alamo?
I don’t think there has been any real problems there for many years. The town is literally just a four way stop. There were some battles during the Civil War fought there and Antietam is just over the mountain. It’s too bad that people were taking signs and such, the original signs were quite nice, now I’m pretty sure they are just metal signs.
Hitchcock’s The Birds.
The Philadelphia Art Museum. People just love to run up the steps and throw their arms up in the air.
Then off they go. Visit the museum? Pfffffft.
At least they did move the horrid statue of Rocky.
First Hunger Games movie was filmed around Asheville NC. The place that stood in for district 12 was overrun with visitors for a while. The state even promoted visits to other filming sites such as Dupont State Forest which is south of Asheville.
When I was growing up in the Olympia area, Forks was known as the methed-out ex-lumber town that you only went through because you had to if you wanted to follow the highway 101 loop. When Twilight became massively popular, my town’s parks and rec department started organizing day-trip excursions for tweens, teens, and their parents to go pretend to be Bella for a day. I don’t know if it’s still going on- there’s no excursion listed in this quarter’s parks and rec catalogue, but who wants to go to a temperate rain forest in January?
How about the Bradbury building in L.A?
Why, there IS no basement at the Alamo! [Laughs and points.] 
However, you can always go here instead:
http://www.vice.com/read/pee-wee-hermans-dinosaurs-are-actually-a-creationist-museum
Real ma-tuuuuuure!
Nice whoosh. 
Pee-Wee did eventually get a tour of the Alamo basement, but it’s a bit of a letdown (just boxes, offices, and fluorescent lighting).
By special invitation only, it would seem. 
Reminds me of the “basement” at the historic site where I was a guide in the '80s.
Albuquerque saw a boost in tourism from Breaking Bad. Several companies offer tours of the various recognizable locations around town. In fact you can even take a tour of the sites in an RV just like the one Walter and Jesse used.
Twenty years ago John Berendt’s Midnight in the Garden of Good and Evil became a bestseller, spent 216 weeks on the New York Times bestseller list in hardcover (that’s over four years!), and got made into a Clint Eastwood movie (co-starring one of the real-life people in the book).
The “non-fiction” book really brought the tourists into town. I knew about this from numerous shows and stories at the time. And it’s still pulling them in:
http://www.trustedtours.com/store/a-walk-through-midnight-tour-of-savannah.aspx
Before the book came out, I could probably tell you maybe one or two things about the city, but not give you any reasons to visit.
*Even Berendt now admits to doing a considerable amount of revision of reality in writing his book.