Only one of my friends had the expansion pack, the rest of us spent plenty time on Goldeneye, brilliant game at the time. Replaying, Goldeneye just seems more enjoyable, that could be a lot of the nostalga kicking in, Perfect Dark is ok, but certainly doesn't have the edge IMO.
I'm gonna disagree with that, I though that the early 3D was pretty sweet at the time and it kept pushing the gaming industry forward. Even the 3D on rails games were good, and on that note Lylat Wars (Starfox64) was full 3D in some game regions as well as in the multiplayer. Can't exactly expect to sit and stagnate on old tech until the new stuff magically appears!
I didn't find that seeing every polygon detracted from it, a good game was a good game. If anything we've started seeing graphics becoming too central.
The scaling issue does exist, but that's more to do with the N64 not being designed for TV's, that generation of consoles made use of the workings of CRT TVs for a number of the lighting effects so they never seem quite right with a flat screen.