As stated by tgannaway89 this topic has been discussed before. I am not sure how to merge the threads. All the information sought after can be found with a simple Google search. Below is opinion and information I provided in a previous thread (links updated for URL changes since the original post).
For a complete list of productions shot in San Antonio visit Film San Antonio at:
San Antonio Filmography :: Official San Antonio Visitor Information: VisitSanAntonio.com
For a complete listing of movies filmed in Texas visit the Texas Film Commission at:
Office of the Governor - Rick Perry
In my opinion the following films, although not all good ones, showcase sites in the city pretty well:
All the Pretty Horses
The Newton Boys
Miss Congeniality
Selena
Blank Check
Cloak and Dagger
The Getaway
Viva Max
Among the TV shows:
Heaven Help Us - short lived syndicated Spelling Production show shot entirely on location in San Antonio - about a newly wed couple that, on the way to a honeymoon, that dies crashing into the RiverCenter Marriott. There they end up in pergatory (on the 13th Floor) where they have to go out and do good deeds in order to be granted entry into Heaven. Starring John Schneider and Ricardo Montalban
J J Starbuck - another short lived series that aired on NBC. Story of a wealthy Texas oil man that travels the country solving crimes in attonement for his focus on business rather than personal relationships. The show was a spin-off of "Tenspeed and Brownshoe" and starred Dale Robertson.
Knight Rider 2000 - made for TV movie (1991) reprising the Knight Rider TV series in the near future, the year 2000. It is interesting to see San Antonio filmed as a 'city of the future.' An interesting bit of trivia, in one scene a character is carrying a Joske's shopping bag, but the store had closed in 1987. Stars David Hasselhoff.
My Two Loves - a groundbreaking made for TV movie about a widow, who a year after losing her husband, is starting a new life, is wooed by her husband's best friend and confides this to a female co-worker. The two women end up forming a romantic relationship. Stars Mariette Hartley and Lynn Redgrave.
Perry Como Christmas in San Antonio - a holiday special that beautifully showcases the city's historic sites and riverwalk. Stars Perry Como, George Strait and Angie Dickinson.