As you can see in the foreground, Potrero Hill is a traditional San Francisco neighborhood with attached houses, small apartment buildings, and street trees. It even has a neighborhood bar with hard-boiled, private-eye vibe. It's less dense than many places. Here, people park in front of their houses.
As you can see in the background, Potrero Hill has a commanding view of downtown, or at least the newer part, south of Market street. Most of those big buildings went up in the last ten years. The building boom was driven by The tech industry's need for office space.
I've heard that in just a few years the city built space for 15,000 people to live and work. And yet people still get squeezed out of gentrifying neighborhoods. Partly that's because tech hubs down the peninsula---Mountain View, Cupertino, Redwood City, etc.---refuse to build housing. Instead they remain true to the vision of their founders: houses on lots of a half acre or more.
Of course there are also neighborhoods in San Francisco that refuse to allow building higher than three stories.
And we all complain about traffic.