I wasn't really talking about voiced prose (only). I dislike narrators in general, anywhere, including “major scripted interactions”, as they break my immersion really hard for whatever reason.
When done well, a good narration can add a lot to the story's tone and verisimilitude. It can make the plot feel like a tale told by a skilled bard. But I suppose not everybody will feel that way; it probably depends on your past experiences.