No, maybe disgusting, definitely enraging, but usuallynot contemptible. Agamemnon is an exception, but he's pretty much the villain in a story without clear villains. Odysseus is heroic in the extreme, not contemptible, but his heroism has nothing to do with good intentions or outcomes, only with displaying his desirability as an ally.