A man was found dead in a car following a shooting incident in Sydney, prompting urgent investigation.