Maybe it was because I grew up in Virginia, but Disney's America sticks out in my mind the most. I remember watching Gov. George Allen talk it up, believing it could bring in billions of dollars in direct/indirect tax dollars. However, it was a pretty horrible idea from the start and was opposed immediately. They wanted to build it very close to famous battlefields. It also would have increased traffic and congestion in Northern Virginia which has been bad for decades. Anyone who's been to the NoVA/Washington D.C. area knows what I'm talking about.
The park was also battled with a lot of silly rumors and hearsay. There were rumors they would have to build a ride or exhibit about slavery which obviously didn't go over well. Plus nobody really wanted to go to theme park based on history anyway. It just didn't sound fun.
If I remember right, Disney wasn't particulary popular at the time anyway. Eisner was in charge and Disney had a real money grubbing reputation then. The project reeked of a money grab and showed a real misunderstanding of what people wanted and how they feel about American history, especially in Northern Virginia.