Yeah, I feel like I have hijacked this thread--Sorry!
But in response to what you asked, matt, generally what I find unpleasant is just attending school. I find myself bored and unchallenged at best, and at worst I feel very angry and resentful at my peers and professors. This is my personal experience, resulting from a variety of circumstances, not alot that has to do with being in the psych major. Although, had I chosen a hard science instead of psychology, I think I would have felt more challenged, and less annoyed with my peers. Psychology has sort of become the default major at a lot of colleges for those people who can't decide what else to do--at least, that has been my sense as I have attended a couple of different programs.
This is just my experience with undergraduate school. It's possible that grad school is completely different, but I have such a bad taste in my mouth from previous schooling that the thought of more school is untenable right now.
I also have a lasting legacy from hating my undergraduate time--a low GPA, which will make it difficult to get into a master's program.
I hope whatever you choose, you have no such difficulties! If you have an ok relationship with academia in general, I don't think the choice of this degree in particular will pose additional difficulties. Certain classes, I do remember people having trouble with, like Human Sexuality or Abnormal Psych. But in any program that isnt super-restrictive, you could just choose to avoid certain classes if you wished.