I find pair programming to be an excellent when you are debugging a problem and need two sets of eyes. It's also great for teaching/learning when a junior developer has banged his/her head against the problem before coming over to a more senior person for help. For research projects or deep thinking exercises, it's pretty counter-productive.