Sure, they are not always at odds. Now playing "optimally" might lead to boring gameplay, and that is one thing, but it goes beyond that. I think the sort of "the character tries to win, so the player tries to win" you describe works better in a game where the rules are simulationistic in a way...