Known for its steep streets, foggy vistas and a certain bridge, there’s more to Northern California’s cultural hub than meets the eye