As someone who was a non-appointed CDO at a company (only because no one else had the backbone to say no) my performance reviews were fine. However, it's a thankless job because it needs to be done and the higher-ups expect someone to do it.

You just better have thick skin if you take on this role. People don't like having their projects questioned and even if you understand the project you just don't understand.