I did soc undergrad, graduating in 3 weeks. so my school supposedly has the best soc program in the country, but I definitely would not do it again if I could go back in time.
That's good that you have an interest in the fucked up power structures in society--you get to hear plenty about that in a variety of topics. It gets repetitive as hell. Unfortunately, in the wrong hands, this can lead to an awful class where it's thinly veiled bitching. I was really into it at first, but I began to think more critically and found myself feeling like I was getting a lot of unchecked rants thrown at me by professors and TAs. A lot of the classes here have a discussion component where you get to listen to other people attempt at coming up with their own theory-supported rants as well. On the other hand, other courses are very heavily based in statistics.
As for research, if you're very self-motivated, you can put together a senior thesis or an independent study, but you'll probably just have one research method focused course as a requirement. Research goes on more at the graduate level here, though there are opportunities to get involved.
I don't think guys like Baudrillard, Foucault, Zisek or other multi-disciplinary thinkers were mentioned once in any of my soc classes. I learned of them through friends in other disciplines. Few of the courses offered here are based in theory only. If they aren't grounded in hard data, then observational and historical sources are used. When theory is discussed, it's usually Weber, Durkheim, Comte, or Marx. Some higher level courses go a bit more into theory.
but all in all, it's a dead end unless you plan to go right to grad or law school--soc does exercise your brain and teach you some good critical thinking and writing skills. On the other hand, psych at least gives you job opportunities. I would go with psych or something else, while reading some of the soc classics on the side. Both are fine for people who don't like other people, though you'll always run into kids who expect you to want to save the world and be highly socially active, probably more so in soc than psych.