Video reviewers can be hit or miss. I like Happy Nerd because he tends to be informative and make you actually want to play games. As for AVGN I like some reviews, but it annoys me when its clear he just sucks at a game or he's deliberately getting stuff wrong (his complaints about Friday the 13th's map screen have always annoyed me because he tries to make it sound so confusing, but it really isn't). The momnt when he got killed by the Orange Sylvester in Bug's Bunnys Crazy Castle is also a source of annoyance. When his show became more skit-focused, it became very hit or miss--I find ROB and Nintendo World Champs enjoyable but usually I dislike the skit episodes.
This all being said, I like video reviews more than written ones. Even being badly done, a video simply conveys more information than a text description does. I can work out how a game works from seeing it in action, but a still photo can be vague, and a description without any pictures is even worse. Besides, text's biggest flaw is that it invites a lot of laziness--text is the medium of instant gratification after all--while even the laziest video takes at least some doing. Those little kids who just point webcams at screens notwithstanding.
I can understand why Irate Gamer is loathed--he DID do a lot of seedy, underhanded stuff--but yeah, there are far worse reviewers out there.