A horror midnight burnout in the NSW Hunter Valley region has left eight people, including two children, injured.