My undergrad experience was enriched with many clinically based courses allowing the faculty to provide vivid stories about their own professional experience.
When i was a part time faculty member at a small private univeristy, the faculty were mostly research based in social psychology. Because of this limited scope majoring in psychology there was vastly different than where i graduated for example. The point of this story is that all major are not created equal. You should google around and see what the faculty at potential schools youa re going to, are into. Take a look at course offerings. If you have the thought of being a therapist, cousenlor, social worker, psychologist etc- make sure you see course offerrings that provide the right experience.