My oldest (12) is not a big ride person- he gets motion sickness and also gets nervous easily. He does, however, love Disney. There are lots of rides there that he enjoys, far more than at local theme parks or fairs. At MK, he loves Buzz Lightyear, Pirates, Haunted Mansion, Seven Dwarves, and Big Thunder Mountain. He also loves the Monsters Inc show. At HS, he likes Toy Story, the Indiana Jones show, and the Star Wars exhibits. At Epcot, he loves Soarin' and Test Track, as well as Living with the Land, Spaceship Earth, Agent P, and the aquarium. At AK, he likes the safari, both animal trails, Kali River, and Flights of Wonder. We also love seeing the street performers and other things around the park.
Oh, and the interactive areas at the end of Spaceship Earth and Mission Space (he does the games while his sib does the ride) are fun, too. My guys could easily spend an hour at the end of Spaceship Earth just goofing around at the different activities.