As far as Yahtzee reviews go it was pretty much glowing haha.
Yahtzee has his schtick so he'll look for things for comedic effect because he's an entertainer, but even the parts of the gameplay he didn't like were often paired up with aspects of it that he did like. There were also aspects of the changes he felt were definite improvements.
There are some games he's infatuated with and they have better reviews from him, but I'd wager the ME2 (in fact, even DAO as well) review is among his more positive.