I love Al Bundy. He's one of the all-timer's in my book but as others have mentioned there are so many other great ones it's tough to give him the crown as the greatest ever.
I would have to go with George Costanza as my goat.
Some other honorable mentions that haven't been brought up yet:
Frasier Crane
Cliff Claven
If you open this up to cartoon characters Homer Simpson