^ You also got it when it was being raped by that gigantic trim. It's hardly the same ride experience as what you'd get if you came back to ride it now.
A few rides that fit this topic for me:
Dragon Challenge - Fun, and I do like them, but I can't say that I love them, especially after how hyped I was for them before my first ride. The Hulk just completely overshadows them in my opinion, though I think I am in the minority on this.
Superman at SFoG for basically the same reasons already mentioned in this topic. Just didn't meet the expectations I had for it.
Anaconda at Kings Dominion - kind of a random one considering nobody expects anything from it anyway, but for some reason I'm kind of a sucker for Arrow multiloopers and I'm fascinated by them, but this one just kind of falls flat. It's built in a very cool setting over a lake, and includes a sizable drop into an underwater tunnel, but after the first few elements and the trim, it's just downright uncomfortable and not very enjoyable.