A man has been shot dead in a targeted attack on a suburban Sydney street. Police are appealing for dashcam footage to assist with the investigation.