That said, I can think of one I always seem to take issue with, and thats when theres some big plot reveal near the end and a character in the know goes on a long info dump explaining it in detail to another character(s) who serve as proxy for the audience. To me, it shows a severe lack of faith in the reader/viewer to be able to put things together on their own through clues and context. It makes me feel handheld and condescended to by the writer and I cant think of an example were this was used that I wasnt taken out of the story. Somewhat related is when crucial information is withheld from the audience with no hint it even exists until it is revealed in a gotcha moment for the sole purpose of making the writing or a character seem more clever. Its cheap and lazy.
Yeah this always makes me think of the ending of Psycho where the psychiatrist describes what was going on with Norman Bates. I think it was a studio decision rather than Hitchcock's