nvidia card has the best picture when it come to media center cards but it a resource hog. ATI has the best compatibility. haupage is the lightest on resources. I have all 3.
I have a sony card that kills all of them (it use no cpu resources), but it only works on sony machines and it isn't MCE compatible