Adriana, even before she became a tragic figure, was more of a comic figure (just her accent alone made her funny) while Carmela was much more of a complex figure. I never got the idea that Carmela was hateable (I didn't hate her) but I didn't really like her either.