I was in a similar situation a few years ago, working at FAANG and living in SCV. Wanted a house more than anything.
Eventually, got relocated to a lower COL area and finally accomplished my dream of owning a home.
Inspector didn’t catch a few things, also bought at the peak of housing mania and now we are both underwater and have sunk a large chunk of our savings into making the house safe and livable for our kids.
If we would have stayed in SCV and rented we’d be in a better financial position. However, overall we are happy with our choices given we don’t have to stress about things like keeping a 3yo quiet for the neighbors who live below us.
Not saying a house won’t make you happy, just saying houses are not a complete measure of financial success.