Not sure how many games actually used the microphone.
Supposedly Takeshi's Challenge, Palutena's Mirror (Kid Icarus) and Zelda FDS.
(I heard the microphone was used to insta-kill the Pols Voices. I know the arrow weakness was added for the NES version (ineffective in FDS version). Not sure about the FC cart version.)