Man shot dead in Sydney’s north-west in 'very brazen attack'