Typically s-video wants to use the player's own comb filters which will be inferior to things nowadays. Composite will bypass this and use whatever the player is hooked to. However, some players will have pretty good filters or the hdtv will have none so it really just depends on which is better case by case.
I've tried both several times and usually don't notice much if any difference.