There is definitely still hope. I had a weak overall GPA. However, just about every other aspect of my application was fairly strong to compensate: High GRE scores, strong LOR's, substantial research experience, poster presentations, and 4.0 psych GPA. I also second the Asher book. My personal statements would have not been as convincing without it.
Despite my low GPA I have been accepted at two fully, funded PhD programs so far.
Best of luck!