I like Yahtzee.
He's entertaining, his opinions are similar to mine at times, and when they are not, well I guess I'm just not "l33t" enough to really care. I'm a comic book fan, so when he took shots at me and my ilk (Batman games, DCUO) I neither took offense or cried foul, I laughed it off, because it was funny (And sadly true in some cases).
As for games, I actually use his reviews as additional info when trying to form opinions, especially if I know little about the game. He may be critical, but he also gives insight into the game, and that is sometimes useful in making a desicion.
His Saints Row 2 review lead to my buying the game for a friend's birthday, and he enjoyed it.
I liked his Batman Reviews (Arkham City and the previous Asylum) but I owned both games when the reviews came out.
I was on the fence about Fallout 3, and his descriptions put me over, and I thank him for that.
I was equally on the fence about Mafia 2, and his (and other reviews) lead me to wait since I concluded that it was not worth the initial $60 price.
He provides an interesting viewpoint (at times) that is presented in an entertaining way that can get me to think about aspects I hadn't considered. And at the end of it all, its just his opinion so if I find I really disagree with what he said, well that's life! I enjoyed Borderlands, which he savaged, yet I still tune in.
Of course his videos, like the games themselves, are subject to the viewer's opinion as to whether they are entertaining or not. If you enjoy them, great, if you find them stupid, well no one is forcing you to keep tuning in.
And as Yahtzee himself said (In the Arkham Asylum video) you don't tune in to see him be nice so he'll pick whatever nits he can find, while admitting that he did actually enjoy a game, or that it was done well, for the most part.