Keep in mind even Stitch had lines when it first opened. The key isn't the first two years an attraction is open its what happens by year five.
Except Snow White's Mine Train is a good attraction. I went on it originally with totally the wrong idea about what it was.
When I got off the first time I asked myself what the heck that attraction was supposed to be.
After having gone on it two more times and thinking about it for a year I think I finally understand it.
The Fantasyland attractions of both
Disneyland and WDW are smaller immersive experiences that give you bite sized versions of some of your favorite stories. Far from the full sized lands like Avatar, Cars, Harambe, Asia, or HP that are all about supporting a single narrative, Fantasyland is supposed to be a speedy trip through many stories. These two ideas are somewhat at odds with each other.
So in a way Snow White's Mine Train is a product of both today's total immersion attractions and the Traditional Fantasyland Concept. The queue, outdoor sections, and show scenes are leaps and bounds more detailed than any other Fantasyland Attraction besides Mermaid (the new Peter Pan's Flight Queue is nice too). Indeed, when you're in the queue it feels like you've been transported to Germany through the eyes of Walt Disney. It's remarkable and beautiful.
Also what is noticeable about Mine Train is how it casts off the burden of trying to explain everything or even tell much of a story. Unlike Peter Pan's Flight, Winnie the Pooh, or even Snow White's Scary Adventure it doesn't seek to retell its source material. It seeks to briefly transport you to the source material for a short time. Show you a moment and get you to feel like you're really there.
Instead of other Fantasyland attractions where you can easily get bored riding them, Mine Train has excellent re-rideability because they're transporting you to a moment not reading you a book. Not just any moment, but a moment everyone knows and loves. This is a more POTC like attraction compared to other ride narrative attractions.
Is it as long or as impressive as Big Thunder or Space Mountain? No, but it's one of the most beautiful and just fun attractions I've been on. It reminded me of Matterhorn, in that it is shorter but just hits all the right notes to be a great ride. I much prefer it to Space Mountain and it's close to Big Thunder. Maybe my new favorite ride at Disney World. It's just a joy to ride.
Cal me delusional, but I think the fanbase surrounding it is more then just hype.