N64 is the worst, no question. I don't agree in the reasoning area so much though.
The 3D was bad? Yes, it was, but bad compared to what? The other two systems were at least as bad.
I also have no problem with cartridges. In case you didn't notice, cartridges have more or less come back with a vengeance. The next generation of consoles is likely to have %100 solid state storage, and the PSP will end up being the only handheld to use discs. The cartridge thing may have held back some of the games because of storage limitation, but it made up for it by sparing us the horrendous load times of the PS.
Also, the controller: while stupid, I didn't find it to be all that badly made. The d-pad is super solid and the buttons, while small, are as good as the SFC controller. Since I never hardly even used my N64 the controllers were in perfect condition when I sold the system.

The biggest problem with the N64 was the whole idea of making something super high end and trying to blow the competition away. This lead to everything just costing too f*cking much development-wise, which lead to small software selection. Nintendo learned from this big time by the time the Cube and Wii came around. The Cube and Wii were cheap to produce and develop for and in the end the sales and profits are really good, even though the software selection is still pretty lackluster aside from a few major releases every year.
The games on the N64 are often times just...bad. Even the first party ones. Yoshi's Island on SFC is basically the best game ever made. Yoshi's Story on N64 is just f*cking terrible. Possibly the worst platformer Nintendo ever made. Mario Kart 64...oh how I hate this game. Again, the SFC one was magic but the N64 one took a high strategic and reflex intensive racing masterpiece and turned it into a game of dice. Shit like blue shells are bad enough, but the rubber band effect is in place at other levels. A racing game where being in first place is the worst place to be is a shitty racing game. Also, they widened the courses and the corners so f*cking much that they turned what was very F1 into basically NASCAR. If you suck at racing, then I'm sure Mario kart 64 is right up you ally.
Favorite games on the system: Wave Race, Pilot Wings.
Regarding people who hate the GC/Wii more...I can't even begin to understand where you are coming from. I can only assume you would be...lets see...23-29 years old? That would place you in a situation where you were very young when the N64 came out and still suffering from rose tinted glasses. The N64 suuuucked. The Cube had mario Sunshine, a (barely) better Waverace, Luigi's Mansion, some Super f*cking Monkey Balls, the Gameboy Player, Killer 7, Alien Hominid, Tales of Symphonia (an actual, real, full on contemporary JRPG, something the N64 never got), that cool Kinikuman game, Phantasy Star Online, Animal Crossing, a very good Gundam game, Bomberman Land 2...way more good stuff that is still more playable than that piece of crap N64. The hardware itself is also exemplary. It virtually never breaks. The small discs leave you with very little load times (virtually none on 1st party releases), cute shape, the Wavebird (best wireless pad ever when it was released), and, again, the Gameboy Player which is rad.
Edit:
And the Wii...the Wii does essentially all this stuff (only the Gameboy Player is lost) plus all the Wii stuff. The Wii shop is loaded with more cool stuff than I have time to play. I give a lot of credit to Nintendo for actually putting all four controller ports and both memory card slots on the Wii and retaining %99 cube compatibility. They didn't have to do that.