As a platform the N64 certainly does have enough quality titles to make it worthwhile, it definitely is over hyped by YouTube fanboyz though... but isn't everything these days?
The main problem with the system is the hardware itself.... the video quality of a stock console is appalling. I personally wouldn't go to the expense of getting one HDMI modded, I'd rather emulate the few games I'd want to play. And although the controller brought analog and rumble to the masses, the execution was piss poor. The Hori Mini pads are what should have been the standard controller.
So yeah, although there are some awesome games, I wouldn't want to mess around with original hardware in 2016. It's one of the few systems I'd rather emulate, especially with the high-res texture packs that are available.
I do think that the Pikachu N64s are probably the most awesome special edition of any console ever though.