Summer crowds have dissipated, hotel rates have wafted downwards, and for many cities, the best local experiences are ready to shine