I think Nintendo 64 has reached god-status due to many college-dorm memories and nostalgia. But overall, it was a bad console, saved only by Rare and Miyamoto. N64 had probably 10 or so killer-apps it will be forever remembered by, but the rest of the library is weak. There is very little variety and diversity outside of that small number of games.
Nintendo's strict and dictatorial attitude made third-parties like Square Enix leave them. The intent was to prevent shovelware, but still 70%+ of it's library got mixed to negative reviews on Metacritic, making it proportionately no better than most consoles. PS1 totally crushed it 3 to 1 in sales. It's controller layout was so illogical too.
Sorry, but the Nintendo DS was just soo much better.