You obviously do not remember the N64-era well, and if I must, PS2/Xbox-era were great as well.
Ready for me to go through the list of N64 games that were good? Here we go (A-Z, because it's easier): Animal Crossing, Army Men: Sarge's Heroes, Banjo-Kazooie, Banjo-Tooie, Battletanx, Battletanx: Global Assault, Bomberman: 64, Duke Nukem 64, Duke Nukem: Zero Hour, F-Zero X, Goldeneye 007, Harvest Moon 64, Kirby 64: The Crystal Shards, LoZ: OoT, LoZ: MM, Mario Kart 64, Mario Party (rage-inducing, but fun, I admit), Mega Man 64, Paper Mario, Perfect Dark, Pokemon Puzzle League (it's actually based on some weird other puzzle game, but very fun), Pokemon Stadium 1/2, I liked Quest 64 but it wasn't that good of a game, Resident Evil 2, Sim City 2000 (Thought it's better on PC), Star Fox 64, Star Wars: Rogue Squadron, Star Wars: Shadows of the Empire, Starcraft (Better on PC), Super Mario 64, Tony Hawk's Pro Skater series were fun, though not that good, Super Smash Brothers 64, Turok: Dinosaur Hunter, Turok 2: Seeds of Evil (this game alone is enough to buy an N64 or get an emulator), Turok 3: Shadows of Oblivion, Turok: Rage Wars, oh,and one I didn't see was 007, the World is Not Enough.
Playstation is where you tend to see a lot more of the shitty games, though they are on every console, but PS1 had a few good ones: Crash Bandicoot 1-3, Dino Crisis 1 and 2, Doom (better on PC), the Final Fantasy series (I hate the games, but I admit that some of them are actually not half bad), The Lost World: Jurassic Park, Parasite Eve (very well made story wise, interesting idea for combat mechanics), the early Resident Evil series (also, very good), Silent Hill.
Xbox and PS2 I'm grouping together, because of the lack of good games percentage wise during this era: Call of Duty: Finest Hour, Halo: CE, Halo 2, Jak and Daxter series, Okami (suprisingly good, feels like it's made by Nintendo), Psi-Ops; The Mindgate Conspiracy (very good game for it's time, deserved a lot more popularity), Rachet and Clank series, Resident Evil series again), somehow missed the GTA series (very fun games), StarWars, Battlefront II.
Gamecube (not much here): LoZ: WW, LoZ: TP, Metroid Prime 1 and 2 (amazing games for their time), Super Smash Brothers Melee.
360 games (I honestly cannot say much for PS3): Alan Wake (decent, though very short), Batman Arkham Asylum/City, Call of Duty 4/World at War, Dark Souls, Fallout series, Farcry 3, Gears of War series, Halo 3, didnt' see Mass Effect, but that series does belong there, Bioshock series, Dead Space 1 & 2
Also, to be fair, especially on prices, think of this: I paid $49.99 for N64 games (not including tax), Xbox/PS2 era it went up to the $59.99 mark, but here's the thing: You got EVERYTHING the game came with; I didn't have to pay $15.00 here, and $15.00 there to get things already put on the disc, if you look at how much bullshit you have to buy DLC nowadays to get what you want, that's already pre-locked on the disc (especially by money-grubbing assholes named EA), you usually end up paying $15.00-$30.00 for things already on the disc.
Yet another problem with today's games, is the huge lack of originality. Most games that are "mainstream" now fall into one of two categories: Shooting people from a first person perspective with regenerating health, shooting people from a 3rd person perspective from conveniently placed chest-high walls everywhere with regenerating health. I seriously can not even say how happy I am every time I play a game WITHOUT regenerating health (I wish it wasn't even in CoD4/WaW). Is it really that hard to invent a mechanic that you have to heal yourself every so often, and/or have a designated medic option in a multiplayer game? Oh, and al of this post-MW2 garbage: +25 for avenging a teammate, +25 for having a decent aim and killing somebody far away, +50 for jacking off in your face, +100 for turning off this game and finding something better to do. Do player REALLY need points for everything they do that isn't even meritable? Even back in the PS2/Xbox/Gamecube era, there was still a lot more originality, and differences between games. Each game had a unique feel and "soul" to it that a lot of newer games lack. As much as I dislike EA, one game I do like from them (and Bioware) is the Mass Effect series. It's one of the very few games that I actually give a fuck about what's going on in the story anymore because of how well the dialogue is done. If developers actually want to put a single-player experience in a game, I don't want it to be the tacked on bullshit, that is so bad, I feel almost insulted to play. BC2/BF3 (BC1 was fun, and entertaining, and tried to be) and ALL modern Call of Duty games I have played have had the most forgettable stories, and laziness I have seen in a long time. And seriously, boss fights nowadays all being quick-time events? One of the most disappointing and insulting parts of FC3 I felt, though I really loved the games, was how lazy the boss fights were. Skyrim had promise: it had amazing environments, but it was really compromised by also an incredibly lazy quest system (everything is a goddamn fetch quest in that game, I swear), bad voice acting (it's always bad though by Bethesda so I forgive that), and very, very grind heavy to the point that it's almost as un-enjoyable as playing an MMO. I was too bored to play past lvl 20, and I'm surprised I made it that far. After playing a modern-day, over the top looking military shooter, just get on your computer, and try to play an older shooter that's been around for awhile like TF2 on a no-crit, highlander (one of each class, special rules) server, that is actually a skill-based class based experience, or even a newer shooter that's good like NS2, and realize how much skill has been removed from most games, and you'll actually feel accomplished when you do good, not from some stroke of luck, or when the game rewards you for something mediocre. It's like getting off of drugs or something, you realize how shit today's shooters/games have become, you do, you really do.
If you really want to look through a list of all the games, before attempting to try to "find the good games" for the N64, or any other game, make sure you try to "find the good games" on the other consoles as well, you'll be surprised as to how many bad games are out there on any console, but more so today.
/rant