“Is a water ride” would probably be better stated as “Will I get wet?” Because a TON of the rides at Disney are technically water rides…but I wouldn’t put It’s A Small World in the same boat (ha!) with Splash Mountain.
Ultimately, I ranked filtering on what others rate (Above average, etc) very low. Why? Because to me that is meaningless data. I’ve learned from here that opinions can be so subjective that something that someone hates another person loves. And how are ratings determined? I, for example, rate People Mover VERY high. But if I were a person who was rating rides based on thrill factor, it would be very low.
Perhaps if there was a rank rides based on categories, and then be able to filter on those categories. LIke: “Thrill level”, “Nostalgia”, “Relaxing”, etc. But seriously, it would be difficult to categorize everything like that. But at least then I could say, “I’m in the mood for just relaxing right now,” and could filter the rides list based on that, etc.
Basically, I just completely ignore the ratings other people give rides in general because I may or may not agree.