I think the PsyD consortium with Stanford is probabaly a good program, but I did not go visit it after finding out about the $30,000 price tag....with living expenses in Palo Alto it becomes crazy expensive.
I know someone who graduated from there (before the stanford consortium) and now works in Neurology in UCSF.
In the end I applied to the Wright Institute in the East Bay b/c it was more reasonably priced.