You could always try one of the many SROs [0] in San Francisco, primarily the tenderloin district.
The former are close to $1500 just for rents (nowhere near SV) and the latter do not seem to be built very much. Very depressing as a native who wants to purchase a simple house in his hometown.
I agree that 1 - 2 bedrooms houses are the perfect size, though. I currently live in one (not in CA).
I think SROs make a lot of sense. It is too bad they have such a bad reputation (justified in SF) of being sketchy places. I wish there were nicer ones.