The Bob Hope movie “Alias Jesse James” is supposed to be set in Missouri, a Missouri supposedly full of dry mountain deserts and rolling California-style hills.
The fictional Pawnee, Indiana in Parks and Recreation; so obviously Los Angleles it’s ridiculous.
The Battle of the Bulge - Belgium in winter sure looked like California in summer.
Wayne’s World features a hip dance club located in Aurora, Illinois. This causes me, and anyone else who grew up in that part of the Fox Valley, laugh bitterly.
Salt Lake City gets a lot of this. From the very first Sherlock Holmes story (a Study in Scarlet), where the Salt Desert lies to the east of the future Salt Lake City to Robin Cook’s Tabernacle (which gets the geography wrong) to many of the true crime books about the Hoffman Documents Scandal, most non-Utahns obviously don’t know Utah.
The only one I’ve read who got it right was Robert Irvine, in his Moroni Traveler mysteries.
I watched Queer as Folk until it got too embarrassing. They’d obviously never even seen a picture of Pittsburgh. There are, like, no bridges in the show at all. None. We never saw one. Let alone a hill.
Then they went to NYC on a road trip and obviously actually bothered to go to New York and it was hilarious.
I’ve never been to Lima, Ohio, but I can wager a guess that they don’t build high schools with a bunch of open corridors in snow country.
A co-worker who had lived in Pittsburgh also said there was no such equivalent as the gay ghetto on the show. There are gay bars of course and as in most cities downtown lofts are popular with childless yuppie couples, but it’s not the Little Castro with gay restaurants/gay law firms/gay newspapers/gay everything like in the show. He was also irked that the newspaper machines were from a paper that had ceased publication years before. He said he did know someone who reminded him of Sharon Gless’s character but she was homeless and deranged. 
The first few scenes of Stuck on You took place on Martha’s Vineyard. It was filmed in Rockport, MA, though. Being that those are my two favorite places, they really didn’t fool me.
Rockport was also used as Sitka, Alaska in The Proposal. There’s one building that has a sign on it that says Sitka. Funny, because it’s supposedly the most painted and photographed building in the world.
I think the funniest one was an interesting use of Gloucester, MA. A few years back there was a scandal because a bunch of high school girls made a pact to get pregnant. Lifetime made a movie out of it. Some of the establishing shots of the town were clearly authentic, as I’ve been to those places. But they made little attempt to reflect the local culture. The only lipservice they paid to it is when a man greets a high school boy who’s on the baseball team. “Hi Mark! How’s your wicked arm?”
We constantly talk about how they get Salem, Massachusetts wrong. If you’ve ever been there, a lot of the older streets are incredibly cramped and narrow. But on Sabrina, the Teen Aged Wicth and in the movieHocus Pocus all the streets are wide and there’s plenty of room. There isn’t a cemetary in the city big enough that you couldn’t comfortably throw a rock at any point from outside the fence – there’s no point in hiding there. Usually, people just take a few establishing shots, then film elsewhere.
Pepper Mill is from Grover’s Mill, New Jersey, so when she saw * Buckaroo Banzai* she laughed her head off. I think the Yoyodyne plant they show is bigger than the entire section of Grover’s Mill. And there aren’t any palm trees there. The scenes of New Brunswick, N.J. were pretty clearly shot elsewhere, too.
The first episode of the tV series War of the Worls, though, was actually shot in Grovers Mill. Right in the park that now has the War of the World monument, in fact.
Well, I’ve been to gay bars. I’ve been to gay bars in bigger cities. I have never been to a gay bar that was on a street with six hundred other gay bars that was crammed to the gills like a particularly ripped Spring Break in Daytona Beach with people dancing, drinking, and getting head in the hallways at 7 on a Wednesday night.
Well, you’re young yet. Meet me in Midtown Atlanta some Pride weekend and I’ll…
Oh, sorry, you meant “in Pittsburgh”.
Sabrina’s not set in Salem, it’s set in the fictional city of Westbridge (although it is in Mass).
Although I’m not actually sure where her college is, it seems to still be in Westbridge, though the opening was mostly shot in Boston for those seasons.
Given this, actually, it seems Westbridge is meant to be like Boston, not like Salem.
In both versions of 3:10 to Yuma, they show Bisbee, Arizona sitting out on the flat prairie.
The real Bisbee is in a canyon in a smal mountain range.
San Antonio, Texas.
When I moved here, I thought it was going to be like the movies - a flat plain allowing Santa Ana tons of space to roam around as he encircles the Alamo, the overly large sun baking the hot dry land below, the only vegetation being some cactuses and tumbleweeds.
Er… that’s more like how it is 600 miles to the west.
SA itself has 31 inches of rain a year, slightly lower than the US average of 37 inches per year and a lot more than, say, Las Vegas, which receives fewer than 5 inches of precipitation a year. It’s pretty green here (well, greener than one would expect if your knowledge about the area comes from old John Wayne movies. :o )
Yeah, but I’ve always suspected it’s intended to be Salem.
They actually did shoot two episodes of the old Bewitched in Salem. I haven’t seen them in ages, but I’ll bet they only used a few establishing shots.
You can actually buy a book in Salem about all the films shot (or set) there.
Another one that bothers me , even though it’s a cartoon, is Disney’s Pocahontas. I want to know where those sheer cliffs and waterfalls are near the Virginia shore. And where the hell are the mosquitos?
One that makes me laugh, though slightly different than the examples in this thread, is the “Raccoon City” that features in the Resident Evil movie franchise - a fictional city, supposedly set in the US, but based on Toronto (and filmed here).
The laugh? That, as every Torontonian knows, calling Toronto ‘Raccoon City’ is not inaccurate - there are more Raccoons in Toronto than humans. 
Many of the planets they visited on the original Star Trek look a lot like Southern Calif.
I thought Westbridge was supposed to be a suburb of Boston and her college was supposed to be in Boston proper. On one hand Sabrina did live on campus, but in the last season her, Roxy, & Morgan didn’t have any difficulties living in the Spellman house and working in Boston.
The film Penelope with Christina Ricci was filmed in London (and very very obviously so) but was supposed to be set in New York. The bit that confuses me about this is that it had no need to be set in New York, in fact given that quite a few of the characters in the film were British it probably would have made more sense for it to be set in London.