I haven't seen that kind of rent since the 70's! A few years back there was a listing for a crawl space (literally hole in the wall of someone's garage) going for $600/month. Craziest part is people actually were interested in renting it.
Nowadays, renting a in-law in the garage can easily go for 2000+; some don't even have kitchens.
San Francisco is a great city and has something to offer for anyone and everyone. However, if you don't already have housing, you will probably spend all your income on rent or mortgage alone. Then you literally don't have money left to do any of the activities that is available in the city. I am not kidding when I say going out to dinner, you can easily spend $100-500 per person (then factor in tax, tip, SF mandate tax). This is just standard dining rates.
If you truly go fancy, I will use SAISON for example, base price is 300/per person (assuming they haven't raised the prices) without any supplements (but who are we kidding, of course you're going to pay an arm or leg for foie gras or uni or blue fin tuna to be added on), then add in wine pairing ($200-1800 per person). Let's do the math: 300 + 200 (cheapest wine pairing) + 15% tip ($75) + 3.5% SF Mandate ($17.5) + 9% tax ($45) = $637.5/per person .
Moral of the story: You need quite a bit of disposable income to truly enjoy living in the city and you won't have that if you're spending it all on housing!