The market downturn is favouring owner-occupiers over investors and offers opportunity for upsizers, as one Sydney sale shows. But it’s bad news for renters