Some of the smaller American cities are also the best for bicycling. Davis and Madison come to mind. Most mid-sized or large cities are outright hellscapes, including most of the cities in the SF area and even most parts of SF itself. A good way to identify a decent bicycling city it to find demographic data on mode share and break it down by gender and age. If your bikers are all 25-year-old males, it’s probably not a great bike town.