Favorite:
That one guy in the woods in ALttP who plays the flute for the animals. That felt like such a tragic fairy tale, love that mysterious feeling.
Honorable mention to the hobo under the bridge in several games.
Least favorite:
Any character that screams in a high pitch.