It really is a shame that the Haunted Mansion movie sucked so much dong. That ride deserved at least as good of treatment as Pirates of the Caribbean. Probably not room for sequels (unless the sequels revolove around different people going on different adventures inside the mansion... maybe) but still...
And while I wouldn't exactly have rushed out to see Country Bears even if it WAS good, it's still unfortunate that they put such a retarded spin on a classic attraction for the movie. Why was it not animated?
Personally, I like that some of the rides have no ties to any movies or other media, it makes them something TOTALLY unique to WDW. However, if they ARE going to make movies based on rides, the least they can do is make them good, if not great movies.
Having said all that, I think you could make a wacky wild west adventure movie whose grand finale takes place on an out of control mining train through Big Thunder Mountain. Expedition Everest and Jungle Cruise are good suggestions too. But I'd rather all of Disney's classic rides stay tributes to classic flim genres rather actual films... unless they turn out as good as the POTC movies (not likely).