Those 3D graphics were incredible and I actually prefer them over the GameCube's graphics. They just have a certain charm to them that couldn't be replicated, except by the PlayStation.
I first played Super Mario 64 about 7 years ago when I was 16, which was a few months before I first joined Super Mario Boards. I enjoyed it a fair amount and would be open to coming back to it in the near ish future (and am currently slowly playing through the DS version, which I think I may prefer to the N64 version) and I definitely respect it was incredibly impressive and revolutionary for its time. But I still personally enjoyed Galaxy 1, Galaxy 2, 3D World, and Odyssey more than this game.
I first played Super Mario 64 in Super Mario 3D All-Stars, and I initially didn't enjoy it too much due to the camera controls and sort of strange movement. But after playing it more, and playing the original "non-remastered" version, I have started to enjoy it a lot more and I now consider it as one of my favorite Mario games! Right now I'm trying to 100% it, and afterwards I might even try some ROM hacks (one of which that has especially captured my attention is B3313)
I also first played it in 3D All-Stars, and while it still sits at #2 of my enjoyment of that set of three (Galaxy 1, Sunshine 3), it was also the second I decided to 100%. Went back through it, got everything, and had a blast. Now that I've found Co-op, the multiplayer fangame for it, my love for it has increased a lot. Heck, I'm learning how to mod said fangame with a custom music pack and such! 30 years of greatness and an opening to 3D games as a whole for the plumber!