I like him in Majora's Mask, he is an interesting character, and I like to see how he identifies with Link, which makes him seem as though he was an older version of Link, a Kokiri adoptee who grew up, but he wasn't a hero.
In Wind Waker, he is fairly annoying. I wouldn't mind paying 398 rupees if it was for a side quest or something, but having to come up with that much x8 seems a bit excessive and gets annoying after a while.