Rebel-TT, great idea for a thread and I'm glad to read your perspective on this. I completely agree, basically. I think it's a pioneering one but not nearly as fun now as it was then when exploring 3D worlds was such a novelty. Collectathon platformers died out in the subsequent gen when the mindset shifted to the idea that how to traverse 3D space was more interesting to play than just getting to traverse 3D space at all. At least when platforming is the focus, I mean. When shooting or traversing an open world is the priority people enjoy traversing 3D space but when platforming is the focus the essence is lost the less platforming you do, IMO.
So I'll just say this, then. I never got much into SMS and when trying it again a couple years back we couldn't get into it then either. But when trying the original linear Sly Cooper again in the past couple years we enjoyed it a ton because of the focused 3D platforming design. And I think there's a thoroughline from there to the SMG Galaxy games, which we loved, to the 3DL and 3DW games which we were also huge on.
(As a side note, another recent 3D platformer we've enjoyed immensely was Snake Pass.)
As an additional note, as big fans of previous 3D Zelda games, BOTW left us cold in a lot of ways, though we mostly focused on exploring and side questing and lots of Koroks before getting burned out 120 hours in, so if we try it again we'll focus more on the main quest and shrines (of which we found some we're great and some not as interesting) and less on the Koroks perhaps.
That all being said, and having gone mostly on media blackout since the January trailer, I was somewhat skeptical of how much we'd enjoy SMO. Having played 15-20 hours, I can say we like it a whole lot and are generally enjoying our time with it more and more as we continue to play it past completion of the main game. The first 5 hours or so were pretty fun and in parts awesome, but it picked up considerably in creativity and fun factor for us thereafter.