Current health benefits have been largely minimal, relative to what was promised/expected (I'm actually not sure if anything was promised, so expected may be a more appropriate word). That being said, looking upon that as a failure is incredibly short sighted and one dimensional.
When the project was started, it was expected to bring about a semi-immediate revolution in medicine. As it turns out, many things relating to genes, genetic regulation, disease, etc. are more complicated than scientists had originally thought, which we discovered because of the human genome project, so this mini-renaissance hasn't really happened. However, to develop new techniques and approaches, new ways of thinking and understanding, we needed to know about this complexity.
Arguing that the HGP has failed patient care (in whatever metrics you choose) is the equivalent to punching a horse you bought to take you on an uncharted journey which turned out to be a lot longer than anticipated. You have to go the distance anyway, no one is to blame for the extra distance, and the horse got you a lot further than you would have on foot.