For the record, I was far more a fan of Galaxy than I was of Mario 64. I felt that Galaxy fulfilled on what 64 set out to do in the same way that Breath of the Wild fulfilled what Ocarina of Time set out to do.
Galaxy, IMO, was the game that most effectively used the hardware provided. While Mario 64 was the best of the initial wave, there were quite a few games (like Banjo Kazooie, Lylat Wars, Goldeneye 007, Mario Kart 64, Diddy Kong, Ocarina of Time, Majora’s Mask, DK64, Conker, Seeds of Evil, etc...) that outshined Mario 64 in terms of impressive N64 usage.
On the other hand, of all 3D Mario games, the one that made the biggest impact on me from a technical standpoint was Super Mario 64. Nothing quite matched that experience. Especially the water effects which remain in my memory as one of the most “whoaaaaaaaah” graphically impressive moments of my life.
Take from that what you will: the way I understand the question is that Mario 64 should be the answer.
I describe myself as a little dose of toxic masculinity.