Check out this building in SOMA, it was finished, sat empty waiting for permits for 2 years because the City sucks, and during that time the condo market crashed and so now the builder had to hand it back to the lender. Full brand new condo building one block from Oracle Park with like 24 luxury condos in it for 16 mil now: https://sfstandard.com/2023/08/16/brand-new-san-francisco-co...
By now I would think most builders can expect 1-2 years for obtaining permits. Not ideal, but it's similar in other large metros.
It takes 6 to 12 months in New York [1]. In the meantime, 90-day temporary COIs are issued.
Permitting hell is a California specialty.
[1] https://propertyclub.nyc/article/certificate-of-occupancy-ny...