Going with 'good'. I still love the N64. Loved it then, love it now, it got a MUCH bigger slice of my buying than my PS1 ever did (my N64 library more than doubles my PS1 library). At the time, I was all about FPS and adventure games, so the N64 definitely had my back. I still remember renting one first, I rented Mario 64 and Shadows of the Empire, and fell in love immediately. Turok, Doom 64 and Goldeneye being the next games I played just cemented it firmly, Doom especially. Everything else that knocked me over at the time was pure gravy (Mario Kart 64, Blast Corps, OoT, Starfox 64, F-Zero X, and the list goes on for me)
Nowadays, I do feel the system got a touch overrated, but what doesn't eventually get there. Especially since now so many of my favorites have all be re-released, with touched up visuals, so well there's not much reason to go back to the original versions, and I'm not talking about VC re-releases that are slightly sharper, I mean like OoT/MM 3D, Starfox 64 3D, Doom 64 EX (user made mod, because Doom community, and amazing), The recent Turok re-release on Steam, so on and so forth. And I loved Mario Kart 64. The tracks remain my favorite of the series. Gameplay? Has NOT aged well. Reaaallly hard to go back after digging into Mario Kart 7 and 8.
Despite this, I still have lots of reasons to go back and play it, so it's one of my retro systems that never gets unhooked. F-Zero X, Blast Corps, the rest of the Turok games, Shadows of the Empire, Paper Mario, that port of Quake 2 that has a completely different set of campaign levels that are a lot of fun still, Blast Corps, Castlevania: Legacy of Darkness, and so on and so forth.
TL/DR;
I love the N64. It's a good system. But there's no doubt lots of folk have their rose coloured glasses on way too tight.