Whether there are cognitive effects is not clear, but it definitely affects their mood and their sleep. It's a touchy subject since astronauts don't like to publicly complain. Scott Kelly talks about it pretty openly in his book; reading between the lines of tech papers on next-generation life support you get the impression that crews insist levels need to get below 2000 ppm for long-duration missions.