Good managers find out what each employee is awesome at and get them doing it. If you hire someone and what they love to do and are great at isn't what you need at your company, then you've hired the wrong person. But I know lots of people who left a job because they kept asking to be moved to a different role, different team, etc, and nothing happened.
Managers: focus on what each person is great at and loves to do.
Unfortunately, most companies and people don't design and execute performance reviews well.
Similarly the results should influence compensation in a meaningful manner? You blew your results out of the water and only get a 1% raise? That's crap. Management's performance sucks in this case (that's why upward reviews are also key).
If you are performing well and delivering results, to then have this annual review process which gives you a big list of all of the extraneous areas that you 'need to improve on' can be a complete sap on the old motivation.
Especially if it's accompanied by the typical 1-2% pay increment. That can really be a drag....
I've quoted this article on the topic a number of times, but it's spot on IMO - http://headrush.typepad.com/creating_passionate_users/2006/0...
If you're going to do them, performance reviews should be about identifying the areas where people are great, and working out how to extract more of that....