Sometimes it's unintentionally comical, when he uses his earnest, excited voice to ask a mundane, obvious question to which there's really only a pat answer.
Searching at random, here's a clip of him interviewing Daniel Day Lewis and Paul Thomas Anderson (Boogie Nights, etc.):
I love that portentous pause when Rose says "religion and .... business". When the camera cuts to PTA and (especially) DDL in turn, it seems like they may be trying to suppress a giggle.