I had it as a kid. Didn't like it as much as my SNES or PS1, the snes having smoother graphics, and the ps1 having better games, and both having better controllers. The N64 controller is the worst of all console controllers imo, even more-so than the xbox controller.
But, it did have some good games. My favorite N64 Mario game is a 3-way tie between Paper Mario, Yoshi Story, and MP3.
Paper Mario because it gave me a slice-of-life look at the Marioverse. Yoshi Story because it was 2d explorative, and MP3 because it had good minigames and a battle mode with a partner system.
I feel the need to also give a nod to Dr.Mario 64 for having a story mode with Wario as the bad guy, I thought that was really funny as a kid.
I never cared much for SM64,
I felt it paled in comparison to SNES Mario Platformers, and any other 3D Platformer (eg. DK64, Spyro).
Mostly because when I think "Mario platformer" I expect it to have the SMB/W flow, where every few step leads to a new obstacle to overcome. But SM64 didn't have that, a lot of it was just running around without much need of jumping.
Growing up whenever I told people this, they'd respond "3d GaMeS cAnT bE LiKe ThAt". Well, jokes on them, 3D Land/World proved them wrong.
Non-mario n64 games I loved were:
All the Pokemon games, especially Hey You Pikachu and Stadium 2.
Then there's Kirby 64, DK 64, the Banjo games, and one Bomberman game that idk the title of.