That is a very hard thing to do for me, i cannot think of a single moment and point at it as this is my favorite or this moment is the best. I played many games that have engaging dialogue that offers good context. For example i think Witcher 3 from recent games has many good engaging dialogue where i could listen for minutes without getting bored, especially the ones in the DLC, however if you ask me to point to a single scene i couldnt. I dont think Witcher 3 relies on those type of scenes anyway, it doesnt try to emotionally manipulate the player into it, like trying too hard to make you laugh or cry or think about something, it doesnt try to appear more deep than it is, doesnt throw pointless cringe comedy at your face, doesnt make characters cry like Anime melodrama to make you get them feels, the dialogue just flows and stay consistent. Its not a bad thing but because of that i cannot point to a single scene where i felt something out of the ordinary. I decided to give this example because this game is popular here. But this example works for films and anime for me as well, i just dont consider plot twists or try hard emotional scenes to be necessary good, they may be good but most of the time they are just cheap ways to make the viewer care because underneath the story will be average.
Most acclaimed WRPGs usually have good dialogue. One scene i like is in Bioshock 2007 where you confront Andrew Ryan and he tells you "Would you Kindly"? I think that was a good moment. Just an example so OP won't say i didnt contribute to his thread