NIOSII design Vs Normal FPGA design

I am trying to understand when should we use nios ii in our design instead of directly designing the system on VHDL? Also, what is the point of using nios processor if at the end we are going to co...