A man has been fatally shot by police after a six-hour standoff at a NSW home, with a critical incident investigation now declared.