Mac, that's almost identical to the list I came up with in my head. I'd probably add western Michigan.
After the top 8, I see a lot of smaller locales and less acclaimed areas that are all roughly even. Places like French Lick, western Nebraska, the RTJ Trail in Alabama, and other locations that are a bit tougher to travel to for most people or maybe a bit less heralded. Streamsong seems like it should be able to compete with that tier right away as far as destination golf goes. It probably wouldn't be my first choice for a golf trip, but if I take one or two every year I'd definitely have it on the long-term list (I thought about going in February with a fellow GCA'er for a long time before deciding to prioritize other destinations until more reviews are in). It's also in a densely populated enough region of the country that it should be able to draw fairly significant local play.
Like Pat, I see things working for and against Streamsong. Having tourist draws locally should help increase traffic, but it also may mean that the resort is always playing second fiddle to places like Disney as attractions in its own market. I think ultimately, though, its success will come down to the quality of the golf, accommodations, and service. In other words, Streamsong will succeed or fail for the same reasons most courses do. It's in a good enough location to thrive and a bad enough location to fail, depending on its ability to nail those three factors. Early reviews suggest Factor 1 is solid, Factor 3 needs some work, and Factor 2 is still TBD. I hope they're able to nail it.