A new one I've been hearing good things about (but haven't read yet) is Zack McDermott's Gorilla and the Bird about being bipolar.

Susanna Kaysen's Girl, Interrupted is a classic. Julie Barton's Dog Medicine is a good memoir about depression.