I used to be big on camo, but now not so much. I am not terribly concerned about the pattern, and the more I hunt, the more I have moved back to solid patterns in earth tones where I can use the gear for other activities.
Another reason for moving to solids is that we hunt more and more in areas that have a strong liberal population (like certain areas of Colorado or Arizona come to mind) and I really don't want to stand out when I am in town buying groceries, at a restaurant for dinner after a day of hunting or leaving a hotel room early in the morning. For example, last year we based a Colorado deer hunt out of a condo in a ski town. No one bats an eye if you are in solid color outdoor gear.
Part of my shift has been the difficulty in getting quality camo gear for my wife, but I can get earth tone solids for her. In our hunts together, I have never seen that camo made the difference in a hunt.
All that said...if you are a camo guy, I think you should generally pick the pattern you like as I doubt the pattern will make much of a difference. If you want to be more critical in your selection, go tans for desert and greens for forest hunts.
In pretty much every situation I can think where camo might have made the difference, I think avoiding movement was far more critical.
