Well, let’s break it down into two categories: the first category are locations that exist in reality in which James Bond has visited i.e. San Francisco, Venice…. The second category are actual locations that substitute for fictional locations i.e. Jamaica for San Monique or secondary locations that substitute for real locations i.e. The Bahamas substituting for The Mediterranean in The Spy Who Loved Me.
The United States [8 cities over the course of 6 films]takes top honors for the most visits. Bond has been to Los Angeles in Moonraker, New York City and New Orleans in Live and Let Die, San Francisco in A View To A Kill, Key West in License to Kill, Miami and Kentucky in Goldfinger, and Las Vegas in Diamonds Are Forever. Los Angeles qualifies as a location in Moonraker since actual film crews went to Los Angeles International airport and did some shooting.
Italy  is the second most visited country. It was used in From Russia With Love, The Spy Who Loved Me, Moonraker, and For Your Eyes Only. Venice was used in ‘Russia’ and Moonraker, Cortina was used in For Your Eyes Only and Sardinia, off the coast of Italy, was used in ‘Spy’.
France  is the third most visited country both in the first and second categories. It was used in Thunderball and A View to A Kill; Bond visited Monaco in Goldeneye. [see SECOND CATEGORY for more visits]
Other multiple locations:
The Bahamas  Thunderball and Never Say Never Again
Germany  Bond visited Berlin in Octopussy and Hamburg in Tomorrow Never Dies.
Spain  Bond visited Gonzalez’s villa outside of Madrid in For Your Eyes Only (even though technically this scene was filmed in Italy) and Balboa in The World Is Not Enough.
Jamaica  Bond goes to Jamaica in Dr.No.
Turkey  Bond visits Turkey in From Russia, With Love and The World Is Not Enough.
Switzerland  Bond visits this country in Goldfinger and On Her Majesty’s Secret Service.
Thailand  Bond visits Bangkok in The Man With The Golden Gun.
England  Bond sees action at the Shrublands Health Clinic in Thunderball, Never Say Never Again; gets involved in a boat chase down the Thames in The World Is Not Enough.
China  Bond visits Hong Kong in You Only Live Twice and The Man with the Golden Gun.
Other locations Bond has visited include Portugal, Holland, Egypt, Brazil, Greece, India, Gibraltar; Austria; Morocco, St. Petersburg (Russia).
France …doubles for parts of California in Moonraker (the Drax estate was filmed outside of Paris), Tomorrow Never Dies and The World Is Not Enough (in both TND and TWINE, mountainous ski resorts such as Chamoix doubled for Afghanistan and Khazikstan respectively).
The Bahamas  substituted for Sardinia’s underwater shots in The Spy Who Loved Me as well as underwater shots in For Your Eyes Only.
Spain  Substituted for the Azerbhijan desert in The World Is Not Enough.
United States …Gainesville, Florida’s swamps and lakes doubled for the Brazilian jungle during the riverboat chase in Moonraker. The mountainous region of Utah doubled for Cuba in Octopussy.
Jamaica  doubles as San Monique in Live and Let Die.
Thailand  Doubles as Vietnam in The World Is Not Enough.
Austria doubled for Czechoslovakia in The Living Daylights.
Quarzazate (Morocco) doubled for Afghanistan.
Switzerland doubled for Russia in the pre-credits sequence of Goldeneye.
Lebanon was doubled on the Pinewood Soundstage; Canada doubled for Austria in The Spy Who Loved Me and Siberia in A View to A Kill.
Acapulco doubled for Isthmus City, while the waters off Isla Mujeres, Mexico doubled for underwater shots off Key West. Rosarito, Mexico doubled for the underwater shots in Tomorrow Never Dies.
Puerto Rico doubled for Cuba in Goldeneye.
**Bond has traveled to five of the world’s seven continents. The only two he has visited are: Antarctica and Australia. He’s been all over Asia and primarily the United States when he has come to North America (curiously he’s never been to Toronto or Vancouver-Canada). He has traveled only once to South America (Isthmus does not count since it is fictional) and has been to nearly every country in Europe at least once. He’s been to parts of North Africa and South Africa, but never anywhere in between (thus missing beautiful locations such as Kenya, The Congo or Zaire).