I don't like... (gasp) Haunted Mansion. I know everybody is obsessed w/ that ride, but I personally don't enjoy it and have skipped it several times.
Okay, I love that one, but never really appreciated it as much until I had the chance to ride it at midnight on a dreary drizzly evening - THAT kind of just made it right. The Haunted Mansion on a bright, sunny Florida day just doesn't have the same creepy factor.
But HM isn't (I don't think) a ride that gets the same "hype" as one's like Soarin', Test Track, Everest, etc. It's given a special status because it is (again, I think) regarded as one of the classics. That, to me, is a little different from hype.
However, I know you aren't alone in not liking it - my wife could easily take it or leave it, and on our last trip she didn't get a chance to go on the ride and she didn't care either.
My choice (and I don't know if this one counts as a ride that gets enough hype) is Pooh in MK. I can only fathom that because little kids MUST go on the ride that it is a FastPass attraction. Even though it is technically far more advanced of a dark ride than the one it replaced (Toad), I don't think it has the same heart and character that Toad did.