Hmm, I'm trying to think back. I've only played Downpour a couple of times. I liked the tell tale heart sidequest and the cinema one. And kind of the gramophone one. I like them to at least be a bit creepy or ominous in nature.
Don't you want to share a favorite? That would've been a good way to start.