A second royal commission into New Zealand's pandemic response has found "scars" were left by the government's handling of COVID-19, but on the whole it was "considered and appropriate".