Just thought of another character I couldn't stand -- Melfi's shrink Kupferberg. Between that stupid water bottle, his butchering the omertà concept, and then him exaggerating his encounter with Tony, the guy is a world class douchebag.

Let's not also forget this line:

"This Santoro thing...I called it a year ago."