Don't forget the gym leader castle and the round 2 of the Stadium games. Those were some of the best tests of skill for the generations both Stadium 1 and 2 were released in, especially if you only had rentals to go by which forced you to really improvise and everything. I've been doing that on Stadium 2 every now and then at this place I go to that has a break room with a bunch of old and current games, and man does it make me wish I still knew where I had my Crystal version or something like that with the transfer pack. lol But I made it to round 2 at least and am somewhere halfway through it with rentals only on the 2nd Stadium, so yeah.
IMO, you've never truly faced the gym leaders or the elite 4 of the first 2 gens until you've played round 2 of the gym leader castle, where you don't get an easy win on them simply due to having a higher level creature.
As am I. That goes for both the Stadiums. Only difference with the cups in Stadium 2 is there's the challenge cup instead of petit cup, which I prefer the former. It's the ultimate test of improvisation, not to mention the ultimate test of patience if you decide to quit and restart the cup until the game randomly gives you a half-decent enough team, which you need on round 2 as you'll get by with nothing subtle when it comes to R2 Ultra Ball. Man...
Back to Pokemon in general, just want to point out that I've given all the generations a fair shot. Gen 1, while the most nostalgic, wasn't actually my favorite. It was gen 2 for different reasons. Gen 3 I was probably the most competitive in, and felt the most alone in in a sense, because I thought I was the only one who liked Cipher/Colosseum until I entered this thread. Now gen 4 I eventually became turned off by with overly cheap things like Stealth Rock, that overhyped Pokegod, Pokemon Battle Revolution (ugh), etc. Not to say gen 4 didn't have anything good about it. It certainly did, but the bad just kinda outweighed the good for me after awhile. Gen 5 has got me back into the swing of things though longer than gen 4 ever did, not to mention the Pokemon themselves of gen 5 and their designs, I probably haven't been so in love with since the poke's of generation 2.
Regarding the earlier mention of Goldeneye and Perfect Dark, I hate that The World Is Not Enough doesn't seem to get the kind of recognition as an N64 game as they do.

I guess because Perfect Dark overshadowed it toward the end of the N64 era due to the timing of their releases or something, but meh.
As for in-game cheats like in Goldeneye, they're still in games today. They're just.. harder to come across in this online-heavy generation, which is understandable. And I like DLC that's done right, but often it's given a bad name by companies like Capcom and the like with the day 1 disc-locked content bullcrap.
Other than that, I don't think I have too much else to add on to what was already talked about earlier, except that nostalgia's a disease that one must not completely succumb to. It's enjoyable to have in small doses, but have too much and you can become one of those people who hates everything of today, or anything that's new in general. I hate those kind of people, lol. Wish I had some things to say about Zelda and other stuff that hasn't already been said, but I don't.