Off the top of my head I have to say Carver and Bloody Mary from Telltale's Walking Dead and Wolf Among Us respectively. Both excels in making you hate the character so much you're just counting down the hours to their eventual demise.

I'm having trouble thinking of anyone who falls on the worst side, so I'll give a blanket answer of forgettable.