I think SWROR got it right with the balance of voice-acting; fantastic stories with the right dialogue! Games like Mass Effect and Dragon Age also got it right with voicing. In 2016, it tends to remove the cinematic storytelling without it.
Of course, it's impossible to have cinematic storytelling without voice acting.
Voice acting suits Mass Effect best as it doesn't set out to have the most role-playing ever. The player character is always a human, is always Shepard, and you can only role-play as a paragon or a renegade. Voice acting is ideal here.
It isn't ideal for Dragon Age: Origins and Inquisition however, games that let you choose your race and gender. But at least Inquisition provides two voice choices for each gender, and like Origins it doesn't have tons of dialogue choices anyway.
But games like Neverwinter Nights 1 and 2, Fallout 1/2/New Vegas, and The Elder Scrolls would never work with a voiced protagonist (but NPCs should be voiced). The Elder Scrolls has way too many race choices and each race sounds unique (except perhaps Bretons and Imperials). Same for the Neverwinter Nights games.
The others have way too many dialogue choices unique to your character build. An example would be how Fallout 2 totally transforms depending on so many different aspects of your character build, like low intelligence:
Fallout, Fallout: New Vegas, and Neverwinter Nights (especially the second) are all similar to that, although not quite as extreme (they don't change as much).