Some thoughts on it:
2023 and 2024 and even 2025 prices were a gift compared to prices during the 2010s boom in city. Chance to buy at decade old prices! Even lower if you adjust for inflation
There was a huge jump in prices similar to today between 2020 and 2021 during the "zero interest rate environment", even though there was a mass exodus from the city during the pandemic and the trajectory of the city looked bleak
Despite the headlines of rising prices, they are still about the same as five years ago after you adjust for inflation
Real estate is prices in San Francisco are volatile!