I was never really a Star Wars fan, so Star Tours is a bit out of the question for me. And I don't like high speed drops or coasters, either. But I do love Toy Story and other classic movies. I also love Broadway musicals.
The backlot tours are kinda fun, but they're more of a show than a ride.
I was pretty excited when I last went because it was sort of a surprise to see Midway Mania. I was a bit disappointed, though. I felt like it was enough having one Toy Story ride that was nothing but shooting games, so it was a little sad for me not just getting to ride through the world of Toy Story, seeing the story of the first movie or two being told before me.
So I'd have to say that The Great Movie ride is my favorite. And I LOVED The Wizard of Oz growing up and until I was 9 on my first trip to WDW, I had NO idea that Disney owned any part of that musical. I was SO happy when the ride turned out of the frightening Alien scene and into the wonderful, colorful and musical Munchkinland of Oz. I think I actually cried a little bit, and I was the only person on the ride who chimed in with all their energy when the Munchkinlanders peeked out and started singing "Ding Dong The Witch Is Dead".
I'd have to say that that ride holds one of the most magical memories I have ever had at WDW.