Undead Merchant is definitely up there on my favourites. Yulia's his Uchigatana, isn't she?
One of my least favourites is also in Dark Souls. I accidentally hit the Undead Female Merchant when walking through the door for the first time, and she keeps yelling at me.I never have the money for absolution either. And she's the only person in the game who sells Poison Arrows!