If I convert VY v6 Commodore from auto to manual, will I need an engineer’s certificate for NSW?

You won't, along as the transmission setup is from a standard equivalent vehicle. For argument's sake, if you went with a custom transmission, with mounts etc, then it would technically need to be certified.