I don't live in the Bay Area, nor do I wish to move there, but I have some thoughts.
It may be that the way to accomplish this is to start a housing co-operative, or a non-profit organization.
The Rochdale principles, which many co-operatives adopt are: Open, voluntary membership. Democratic governance. Limited return on equity. Surplus belongs to members. Education of members and public in cooperative principles. Cooperation between cooperatives.
If that seems like something you can live with, then you might want to go the co-op route. If you want to have more control over who joins, and the "open voluntary membership" is a sticking point, then a non-profit might serve your needs better.
In Canada, where I live, becoming a registered charity is much more difficult than becoming a non-profit. In the United States, it is easier to get charity status. My friendly neighbourhood local makerspace, founded by a bunch of my friends, decided to be a non-profit rather than a registered charity or a co-op.
You might find resources related to housing co-operatives or non-profit governance that could help. They have some experience with being able to resolve disputes and keep community standards. I know of some where I live, but I'm not familiar with what's available in the Bay Area. Resources about intentional communites might help too. This is anecdata, but I've heard mostly horror stories about intentional communites, and mostly good things about co-ops, and co-ops near where I live in Ontario are sought-after places with long waiting lists even when they don't include government-funded subsidized housing, so if I was going to set this up I'd lean more toward the co-op side of things.
Rationalists like to live in group houses. We are also as a subculture moving more and more into a child-having phase of our lives. These things don't cooperate super well - I live in a four bedroom house because we like having roommates and guests, but if we have three kids and don't make them share we will in a few years have no spare rooms at all. This is frustrating in part because amenable roommates are incredibly useful as alloparents if you value things like "going to the bathroom unaccompanied" and "eating food without being screamed at", neither of which are reasonable "get a friend to drive for ten minutes to spell me" situations. Meanwhile there are also people we like living around who don't want to cohabit with a small child, which is completely reasonable, small children are not for everyone.
For this and other complaints ("househunting sucks", "I can't drive and need private space but want friends accessible", whatever) the ideal solution seems to be somewhere along the spectrum between "a street with a lot of rationalists living on it" (no rationalist-friendly entity controls all those houses and it's easy for minor fluctuations to wreck the intentional community thing) and "a dorm" (sorta hard to get access to those once you're out of college, usually not enough kitchens or space for adult life). There's a name for a thing halfway between those, at least in German - "baugruppe" - buuuuut this would require community or sympathetic-individual control of a space and the money to convert it if it's not already baugruppe-shaped.
Maybe if I complain about this in public a millionaire will step forward or we'll be able to come up with a coherent enough vision to crowdfund it or something. I think there is easily enough demand for a couple of ten-to-twenty-adult baugruppen (one in the east bay and one in the south bay) or even more/larger, if the structures materialized. Here are some bulleted lists.
Desiderata:
Obstacles:
Please share this wherever rationalists may be looking; it's definitely the sort of thing better done with more eyes on it.