Final Episode, The Cardboard Box
It seems so appropriate that Holmes' final words in the last episode in the series were:
"What is the meaning of it, Watson?" said Holmes solemnly as he laid down the paper. "What object is served by this circle of misery and violence and fear? It must tend to some end, or else our universe is ruled by chance, which is unthinkable. But what end? There is the great standing perennial problem to which human reason is as far from an answer as ever."
Of course, that quote is from the book, but he pretty much said the same thing in the episode.
I enjoyed that small insight into Holmes' spiritual beliefs and/or lack thereof.
"I have seen what lies beneath."
http://michaeldavis.wordpress.com