Good RPGs that have too much dialogue?

You should play the Persona games.

Sometimes they just go on forever (puke)

I immediately think of Obsidian. I really hate descriptive texts inserted in the dialogues, because they break the flow of the play-like interactions. When I was young, I loved reading texts of classical theatre plays, particularly comedies, enjoying those quick-witted exchanges, and I the descriptive texts just make me so mad...

Too much dialogue in RPGs? Well, I don't think so actually. But I would agree, that a game like Mass Effect 2 got the pacing just right, a feat that does not happen with all RPGs. A lot of them have what I like to call the "found new village" syndrome. That is to say, their pacing is off. Whenever you find a new town or settlement, in many RPGs, you spend a lot of time talking to everyone and picking up a crap ton of quests (this may take as long as 2-3 hours, where you don't do anything but talk to people). After this si done, you go into the wilderness and complete the quest objectives (that's a couple of hours of combat and exploration). Then you go back and collect all the rewards and conclude the quests (just talking again).
That's not great pacing and sometimes, I do catch myself sighing whenever I walk into a new village (especially on replays).
Bethesda games are particularly plagued with this one. In Skyrim, you reach, say, Riften and you just know you'll spend the next hour talking to every NPC you can find, listen to their life story and pick up quests before heading out into the country side and doing one after another. Sometimes, I think Bethesda would have done better placing an NPC at the entrance to every dungeon to give you your quest there.

Some RPGs remedy the situation by making the conclusion of one quest trigger another. This is great but it often ends up in a lot of backtracking.

Getting the balance just right is not an easy thing to do. Ideally, you want to design your quests in such a way that you spread out the dialogue and the combat/exploration. Set up NPCs outside of villages or ambush the protagonist at some point, even in a hub. You know, mix things up. If a game gets this right, it can have as much dialogue as it wants but you don't feel like you get bogged down in it.

In recent years, BW does an ever better job with this I think. ME2 and 3 especially got this balanced out pretty (though of course, they have the advantage of being rather linear). Mass Effect 1 had the "New village" syndrome, particularly when you reached the Citadel. It's also one of the things that made the Witcher 3 such a well received RPG I think. They did get the balance right by distributing quests well and not overwhelming you with quest givers all concentrated in one point. Even in the biggest city, Novigrad, most quests were rather immediate and often involved a combination of talking, fighting, exploring and problem solving (only those witcher senses may admittedly have been a bit overused.

So I don't agree with the OP that RPGs have too much dialogue but I do agree that pacing and properly timed variety of activities are crucial for an entertaining experience and not all RPGs have gotten that one right.