Evaluative metering places emphasis on the AF point, which the camera assumes is where the important subject is. However, it also takes into consideration the reading from the other parts of the frame and based on information of similar scenes stored in a database, an appropriate exposure setting is calclulated. Using evaluative metering, scenes like those that are backlit would give you a better picture than if the center-weighted average metering had been used. Evaluative metering only work when the camera is in AF mode. If you switch to manual focusing of the lens, the camera defaults to center-weighted average metering.
For scenes where the entire frame has equal importance with no particuclar subject, such as an ordinary landscape, or where the entire frame is filled with the subject, center-weighted average metering would give you a good exposure. But that's not to say that the other metering modes can't be used in a similar situation.
If you care more about getting the subject properly exposed without regard to the exposure of the background, then you would use partial metering with the center area over the subject. This ensures that the exposure reading is not influenced much by the background.
I don't think there is any one particular metering mode that is better or superior to the others. It all a matter of knowing how each behaves and using each to your advantage. Obviously it's going to take some time to get familiar with each of these metering modes but that will only happen if spend some time with each mode. Most people are happy just using the evaluative metering mode. Others feel more comfortable using the averaged metering because it's more predictable than evaluative.
