I really like Regent Cid in FFIX. A ruler of a kingdom who gets turned into an oglop by his wife because of all his womanising - what's not to love?