RE4 had the most cheesy and corny answers from a character whenever Leon talked. It was annoying.
I can only remember excellent voice acting in PC games, on the top of my head, Homeworld 2 and Half Life 2. Half Life 2's was decent because the game was almost cinematic, so voice acting was ok, it was a linear game. HW 2 voice acting only had long speeches in the cutscenes, and in battle its only battle chatter, which actually enhances the experience, (although in the case of HW 2, not linear because its an strategy game). Its the only rare ocasion Ive seen voice acting is a really nice adittion.
Zelda is, if anything, anti-linear, and the amount of voice acting needed would be huge, not to mention totally unnecesary.