During my interviewing process I had a lot of experience with both programs there. The program in the psych dept is a great program, very reputable, and is very research focused. It has pros and cons like any program and it depends on your fit with it.
The Curry program is more clinically focused, with more of a focus on children and families. This is from the Curry website and I think it's accurate.
Both our program and the psychology department's program are APA-accredited doctoral programs designed to train clinical psychologists who can combine scientific inquiry with clinical practice. We encourage you to learn about the clinical psychology program in the Department of Psychology directly from their website and admissions materials. Generally speaking, our program provides many opportunities for research and practice related to children and families, and we have special interests in work with schools. We also focus on adult and forensic populations. Most (62%) of our graduates seek careers in a diverse set of mental health service organizations including hospitals, medical centers, schools, and primary health care practices, working with children, adolescents, and adults.
I would say if you are more interested in research, go with the psych dept, and if you are more interested in practice, go for Curry. Also if you are interested in school psych it is a good program. I don't know if stipend will matter to you at all, but Curry does not give much of a stipend to its students. I got this info from the frequently asked questions section, and if you haven't look at those at each school I would do so, they are usually very helpful. Let me know if you have any other questions about these programs, I'll help if I can.