If SF really gave a crap about aesthetics, they would tax residents like you in order to clean up its streets and build affordable housing (hello skyscrapers) for the homeless people who are ruining the aesthetics of such a 'beautiful' city. Good luck bringing your kids to one of the 'many parks' in the city to play without being worried about getting pricked with a used needle hidden in the grass, or walk to that beautiful 200year old stone church without getting harassed by the homeless.

SF is overrated. The reason you would pay $3000 for a tiny studio is because commuting into the city to work for one of the megacorporations is untenable. There are much nicer places to live in the Peninsula and South Bay, or even in other states.