We're currently going through the hell that is selecting colors for the kitchen and dining room. I'm the first one to admit that I don't have the interior designer's flair for picking paint colors. Hell, I'd rather go to the dentist than deal with picking colors.
It isn't that picking the main color is so bad, you just find one that you like and go with it. What sucks is trying to find the other colors that will go with it, for the trim and accents and such. There are lots of books that tell you how to do it, but they either give you a few simple examples, or they are loaded up with theory that doesn't really help those of us that are color challenged.