The story tells you how the greed can lead to destruction. This time, you can see Sherlock Holmes trying to unfold the mystery of the treasure before which you will see him having cocaine to serve his mind. He feels that there's nothing to live for if you don't get to work on challenging things in life. What a waste of life if you are there to just stand by the window and watch. It's doesn't serve the purpose of life.
This treasure hunt story ends with nobody getting treasure except Dr. Watson who finds himself a very charming young lady Mrs. Morstan.