I would do any ride if there was no line, with the exception of M:S if inclined to motion sickness.
I did Sounds Dangerous once. I was cool and dark and I got to sit down for a bit. It is a good place to head if you are hot, tired, or need to nurse a baby. When you leave there are some fun "Movie" machines to play with.
Astro Orbiter I did once too because there was finally a short time. The ride is nothing. The cars are very tight, but the view of the MK is great. We noticed that everyone coming down on the elevator looked miserable, so we got the people on our elevator ride to all laugh, smile, and talk about how great the ride was when we got off. One of the fun things about WDW is how willing people are to play along.
Country Bears I did once. All I can say is that it might be a good place to sit during heavy rain, but it might be better just to stand out in the rain.
I like Tom Sawyer Island. It's not the place you want to be if you are short of time, but if you have the time it's fun. I told my kids that there were scary things in the cave before we went in. It was a pretty good joke since they are big kids. I would love to have been able to play in that fort as a child.
I also really like Ellen's ride and the Timekeeper.
But why has no one has mentioned the scariest, most horrible ride of all...Land of the Demented Dolls!!!