Ploof, its a good question that you are asking, and I'm not a camo expert, but it seems like several posters have given you your answer already.
The names of the camos don't sound like names, but "Realtree", or "Woodland, Fall" ARE the names of the camo print types. All major brands will carry a version of "Mossy Oak" or "Summer Woodland" or somesuch. I odn't know if certain brands are better, but the woody names that you have been given are the names that you should research.
Now, if you want the military camo, like cadpat etc, well that's totally different, but frankly you'd probably be better off with civilian hunting gear, unless you plan on facing off with soldiers. It's cheaper, and you might even get away with wearing it in public if its hunting season.
Uhm... you say north america, woodland, - that will change season by season - obviously get a winter woodland for winter and a summer one for summer.
The best place to ask these questions and to see side by side is not online in a forum. Go to an outdoor/hunting retailer and look at their gear and talk to the store people. They can probably help you. The gear they sell will probably be good for the local area that they are in! SO if you live near the store, the gear will be for your area.
Hopefully this clears it up.