The SNES was probably my favorite console of all time as well. I'm not sure why it was so great, but the fierce competition with Sega probably had a lot to do with it. I never really got into the N64 as I was bummed out with gaming during those years, but I can see why Super Mario 64 and the Zeldas are consistently topping the top 10 games of all time lists. The N64 may have had less games than the GC did (I'm not sure on that) but the quality of the N64 games, especially 1st party N64 games, is undeniable. The PS1 had the highest market share and clearly won that generation in terms of profit and so forth, but when it comes to quality of games I think the N64 easily wins. Aside from the FF games, what was there for the PS1 that is still remembered and played these days? The PS1 library was larger, but it seems to have been inflated by shovelware.
But Ian is right - the SNES had the 3rd party support the PS2 had last gen. The NES had nearly a monopoly on marketshare, but for some reason I didn't like the NES as well. The reason for that is partly from the limitations of the hardware, and probably also from the lack of any meaningful competition. A console without any competition is going to get overloaded with shovelware. But on the other hand, a console with too much competition will end up like the GC with a very small library of games. I think the SNES struck the perfect balance, and I've not yet seen a console which comes close. The N64 was even better with quality of games, but they had too much competition and that hurt the quantity of games. 5-10 AAA games is great, but you need a library of hundreds in order to get marketshare. But yeah, those N64 classics will always be remembered and acclaimed, whereas the PS1 library has already been mostly forgotten.