I also lived in Cleveland when this song dominated the airwaves (Wild Horses played often at the biker bar next door to where I lived):
I remember that!
Not?
“Burn On” played over the opening credits of Major League, set in Cleveland.
I’ve lived here since 1989 and FWIW have never heard Funky Poodle’s “Wild Horses” before.
This song, by a Cleveland-born singer/songwriter, has gotten a lot of airplay here over the years, but it could be about just about any Midwestern city:
Wild Horses is the name of the band. Funky Poodle is the name of the song.
Either way. 
If you’re from Nanaimo, BC, there’s a song for you:
Nope. Vienna is The Whistling Capital of the World, so the Billy Joel song is their song.
Although Merv Grifin was the 12th performer to come along to record “You Came a Long Way From St. Louis”, those other three will have to take a back seat to Merv:
It’s just way more hepcat-sounding.
There are a few more place songs that this board would consider dark, unsettling and/or just plain ol’ inappropriate, so I’ll just sidestep out of that one.
I’d imagine the inhabitants would mostly be unaware, unless one of their own songs had been translated and become a hit in another language - several songs in English about Paris, for example, or Tulips From Amsterdam or Mouse In A Windmill in Old Amsterdam.
You know how bands will do a shout-out to the city where they’re performing? I once saw the blues band Anson Funderburg and the Rockets featuring Sam Meyers at a small club in Pittsburgh. After their first song, Anson yelled, “How’s it going, Cleveland?”.
He was touring and exhausted, totally lost track of where he was.
My favorite example of that kind of cheap heat is from seeing Kiss at an amphitheater on the outskirts of Seattle about ten years back;
Paul Stanley: You know, last night we were down in Portland, Oregon…
The Audience: (boos)
Paul Stanley: That’s funny. They said the same thing about you!