The common code seems to be that doing it out of revenge rather out of conviction makes characters more relatable because it means that they don't have to be noble.

Personally, I actually often prefer characters who do it because it is their conviction because to many tragic/lost someone characters rub me in the "stop hunting/fighting and get a shrink" way.