One that come to my mind is in Warthog school, the potion teacher starts talking very crudely to Penny to showcase the effect of the Veritaserum potion.
I noticed it two or three other situations but I can’t remember the exact scenes.
Hm, ok. I don't agree with you there but thanks for the example. The scene sure is absurd, but meant to be funny. It also gradually gets more hardcore as the scene goes on, it could be a lot more jarring than this.
An even better example that comes to mind would be Elliot from the Collector's mansion. That was quite unexpected. But also kind of mimicing what the player was probably thinking. Yeah, can't share your sentiment here, sorry :P