Gotta be Tessio.

Sure, Carlo's act was bad, but he was a strunz from the start. Sure, he helped kill Sonny, but IF Tessio's plan had worked it would have meant that Michael would be dead, too.

Tessio had a very important position in the Family but his greed got the best of him. Perhaps the title of this thread should be "Least Favorite Traitor".