I recently bought Manic Depressive Illness (the 2007 2nd edition) by Goodwin-Jamison. I haven't made it very far, but it appears to be extremely thorough. It's a huge and heavy hardcover book with 1,000 plus pages, 2 columns of text per page!

I also got Psychotropic Drug Handbook by Paul J Perry, Bruce Alexander, Barry Liskow, and C. Lindsay DeVane.
It's a spiral bound book that is very technical in nature, but also very interesting to read. It goes over the different psychotropic drug classes and shows findings from various studies (i.e., how effective a particular drug is for a given indication) that have been done over the years, as well as more detailed information regarding reported side-effects, etc. It goes over meds for depression, mania, schizophrenia, other illnesses, and all sorts of anxiety related disorders. I think it's good to have a solid understanding about the drugs you take and this book can give you that.