I visit many of these sites when I can (for instance, Hopewell Culture National Historic Park, Emerald Mound, and Poverty Point), and there just isn't really much to really bring in tourists. There's absolutely no comparison to something like Tikal in Guatemala. I wouldn't recommend them to any casual tourists. The only reason I went to these sites is that I'm in the process of visiting all of the national park system units in the United States.
The Anasazi ruins in the Southwest are much easier to understand - Mesa Verde and Canyon de Chelly have extremely striking settings, and the lack of vegetation means that the underlying structure is easy to see. When I visited Hovenweep, I found a pottery shard that rodents had dug up, and when I visited Mesa Verde, rodents had brought an ancient corn cob to the surface - so it's a lot more fun to visit these sites.
Also, Mesa Verde is pretty close to Durango, CO, and is on the "Grand Circle" tour of southwest US national parks, forests, and monuments. So it's going to get a lot more tourists than something like Chaco Canyon which is way off the beaten path, and doesn't have much infrastructure.