Contrary to popular belief, Yahtzee's stuff is not just a tirade of genital humour and swear words. I find that he often has a lot of very valid and well-considered points to make about most games, and he clearly knows his stuff.
However, as with any other review, I don't let his word define what games I buy (if I did, I'd never buy anything), many of the games that Yahtzee has hated I have bought and enjoyed, and some of the games he has praised (I wouldn't say 'loved') I have found to be not my cup-of-tea.
In addition, I acknowledge that a good number of the views expressed in Zero Punctuation are true. Borderplands felt unfinished, Super Smursh Brothers is frustrating, Metal Gear Stolid is pretentious and overly cinematic, Gears of Snore is unsubtle and loud-mouth and Fables 2 and 3 are both a touch on the clunky and unwieldy side, and Portal is GOD! I enjoy all of these games, but in no way suggest that any one of them is perfect.