To me not everything has to be spectacular. I'm fine with smaller simpler offerings. The one caveat is the smaller offerings have to cost like their scale. The Rat was expensive, but garnered only moderate results. I want something that is E Ticket priced to be of E Ticket Quality and scale. Adding diversity of attractions can only be looked at as a plus, so long as they're not blowing through capital (like Toy Story Land).
Yeah, to piggyback off this I think part of the reason people do wonder about how much a ride costs, whether or not it's presented as a major attraction, etc., is because it impacts your expectations of the ride going into it, which can have a major effect on your final impression once you've experienced it.
For a long time, Disney, at least on the Orlando side of things, seemed to grow their experiences, as 60s introduced Pirates and Mansion, the 80s brought about the EPCOT pavilion style rides/shows/etc. that could range from 12 to even 40 minutes (then more if there's a larger pavilion to explore, e.g. how Imagination was sometimes a 2 hour stop when I was a kid), the 90s saw some of the big shows at MGM, the '00s brought along Kilimanjaro Safaris, all that jazz.
Recently, though, it feels we're getting a lot of hype for rides that end up being very short, and often underwhelming, and seeing major changes made or major money dropped and then getting an experience that doesn't even reach 5 minutes from the time you sit down to the time you exit can be a bit jarring. Those experiences still work in certain settings; for example, it's largely what Fantasyland was built on. However, in Fantasyland it worked a bit more given the layout, the architecture, and the overall vibe that was put forward; these were simpler rides, more straightforward, and you didn't get on them expecting to be whisked away for 12-15 minutes the way you would on Horizons or Spaceship Earth. Even Maelstrom, a short ride, was still paired with the port town and the short Spirit of Norway film, making a short ride into a more complete, 15 minute-or-so experience.
In this way, it may feel like a bit of a step backwards, or at least a bit confusing given what we've had built up over the years in our expectations.