Is the "Bay Tour" flight path documented, or is it a more informal route? Are there similar flight paths for other cities?
There certainly are similar routes - the Niagara Scenic Falls route, given in FAR 93.71 comes to mind.  (FAR 93 has plenty of these, by the way.)


  Comply with the following procedures when conducting flight over the
  area described in paragraph (a) of this section:
  
  (1) Fly a clockwise pattern;
  
  (2) Do not proceed north of the Rainbow Bridge;
  
  (3) Prior to joining the pattern, broadcast flight intentions on
  frequency 122.05 Mhz, giving altitude and position, and monitor the
  frequency while in the pattern;
  
  (4) Use the Niagara Falls airport altimeter setting. Contact Niagara
  Falls Airport Traffic Control Tower to obtain the current altimeter
  setting, to facilitate the exchange of traffic
  advisories/restrictions, and to reduce the risk of midair collisions
  between aircraft operating in the vicinity of the Falls. If the
  Control Tower is closed, use the appropriate Automatic Terminal
  Information Service (ATIS) Frequency;
  
  (5) Do not exceed 130 knots;
  
  (6) Anticipate heavy congestion of VFR traffic at or above 3,500 feet
  MSL; and
  
  (7) Use caution to avoid high-speed civil and military aircraft
  transiting the area to or from Niagara Falls Airport.