The area around the Sydney Harbor Bridge is smack downtown Sydney in a very expensive area, equivalent to the Marina/North Beach/Russian Hill in SF. To compare that to what you can rent for in Hayward or even Foster City isn't anywhere near an apples to apples comparison, and as such is entirely pointless.
By the way, I've been waiting to buy a house on a dip in SF since I first moved there in 1998. Prices have moved monotonically upward ever since, even in the dot com bust and 2008 crisis they only stopped moving up, never dipped. Clearly your patience needs to be on a geological timescale if you're applying it to the SF housing "bubble".