i see a lot of people claim that calling out Sunshine for its glitchiness without being even harsher on sm64 is hypocritical but I disagree.
Super Mario 64 is a very primitive game by today's standards and it's not flawless, but it also understands its own limits. It doesn't have overly ambitious level design with more complex geometry than its physics engine is optimized to handle. So while glitches are still present, most of them require you to be trying to pull them off and the ones that randomly slap you in the face are both rarer and when they do happen they're less likely to result in "oh now you're dead"
I don't know how much of my bias comes from growing up on SM64 (both versions), skipping to Galaxy, and not playing Sunshine until adulthood, but I feel like this explanation is at least an attempt to articulate the differences I perceive in a context that isn't nostalgia biased. But I will admit Sunshine looking graphically closer to Galaxy subconsciously made me expect it to be as polished as Galaxy. And i wasn't nearly as analytical when first experiencing SM64.
oops this turned into arguably more of a Sunshine dunk than a SM64 defense but idk they play into each other and constantly get compared so i think it's valid. SM64 defined my childhood, it was my first 3D game, all its imperfections were things I got used to because of how magical it was to be playing it. When I grew older, my mindset became more analytical and critical, and that's when I played Sunshine for the first time. I tried to have a magical experience like with SM64 but just got frustration instead.
the DS version similarly was also something I experienced young enough to feel genuine nostalgia and wonder for. I was like 9 when it came out, and honestly had only been playing the original for a couple years at that point, but the idea of being able to take it on the go had already become mythical to me. And suddenly it was real. Not only that, but it had Luigi, it had more levels, it had WARIO even. Yeah the D-pad wasn't the most fluid control scheme but considering I'd always fantasized about playing SM64 on the Game Boy Advance having to control it with the d-pad was a concession I was always aware would need to be made. To me, a minor inconvenience for the insanely surreal experience of... actually.... experiencing... SM64.... on the go! It's something we take for granted now, with the console and handheld literally just being The Same System now, but back then? God I wish I could feel that magic again.