It's interesting to me, the shift I've had to co-op games over the years (both board and video games). With one group of friends, we play exclusively cooperative games, whereas another only wants to ever play competitive games. For me, co-op is just so much more relaxing. It's also far more social, whereas playing competitive games the socializing usually happens outside of the game itself. You can definitely be over-competitive in cooperative games too though.
Unless the game designers specifically accounted for it, cooperative games can rob the autonomy of less confident players. One overbearing player can hijack the whole game. To them to win the game as designed it feels correct to do.
In competitive game it's possible the less skilled player may never win (not true for party games), but at least only they are personally invested in their win so no one can righteously take over.