Condo prices have gone down in the Bay Area since COVID. The problem is everyone wants a SFH suburban lifestyle in the Peninsula, Marin, or East Bay hills. That’s a luxury and you’re going to pay a premium for it.
I'd make SF and all the large costal cities look like this https://upload.wikimedia.org/wikipedia/commons/a/a4/Hong_Kon.... That is enough density to have a condo cost 100k instead of 500k. Sure there will be a decent amount of taxes and HOA fees, but that would turn housing into a utility rather than a government subsidy for the middle class. Also you could wire fibre to each unit and solve the internet speed problem for these NIMBYified cities.