Very unique celebrity voices can improve a game. See; Patrick Stewart in Obliv and Castlevania LOS. It's just some basic narration but he made it feel suitably epic.
However, the voice acting is way secondary to the mo-cap work. If a bunch of NPCs are all just standing around and talking to me with blank stares it really doesn't matter how much they're mastering the material in the booth.