THIS. Graduate rankings do not necessarily correlate with the strength of the undergraduate education, particularly in an extremely broad field like psychology. Many schools which are unranked for various disciplines, often provide stellar undergraduate educations.
Keep in mind that psychology is one of the most popular majors at most schools. Therefore it’s in many school’s best interests to allocate quite a bit of funding to their psychology programs given that the demand is often very high.
You’re not getting into the UCs. To even be considered for admission you must have at least a [3.4 UC GPA](http://admission.universityofcalifornia.edu/freshman/out-of-state/). That means you only have two schools on your list, the University of Michigan and Michigan State University. University of Michigan will almost certainly reject you, meaning that you have one likely school, MSU to choose from. If you like MSU, great. I would still apply to at least one more Michigan public university, such as Central, Western, or GVSU so as to make sure you have at least one option come next year.
If you can afford out of state tuition, many state flagships with good psych programs will admit you, as well as non flagship publics. Such schools include the University of Iowa, University of Oregon, and the Miami University of Ohio.
I would also strongly suggest considering privates including medium sized universities and liberal arts colleges.