The most agreed-upon effect appears to be that the parasite results in decreased neophilia. What a sensationalist story like this one will not tell you is that the observed effects are "rather low":
Our results showed that CMV infected subjects had lower scores in the personality dimension novelty seeking than the CMV-free subjects. Novelty seeking in infected subjects negatively correlated with levels of anti-CMV antibodies. Negative correlation was also found between novelty seeking and Toxoplasma-infection in Prague, while in villages and smaller cities the correlation was not significant. The effect of both infections, although highly significant, was rather low, explaining about 2 % of total variability of the novelty seeking in our experimental set.
http://www.biomedcentral.com/1471-2334/5/54
Further, while cats are this parasite's original host, it seems that you're as likely to become infected form undercooked meat as from water polluted with cat fecal matter. I guess that's not as much fun as saying "cats are bad, now everyone fight!" I love how every media outlet picked this up as soon ('06, granted) as possible but it took Reuters a month to report on conclusive findings that marijuana consumption results in lower incidence of head and neck cancer.