Pokemon Snap has to be one of the games that the fandom requests a remake the most, second to the Hoenn games. I had a working copy when I was a kid and still had it with my N64. After hearing how good the game is, I decided to finally pull the dusty cartridge out and play it.
Overall, it aged nicely. Not the best, but it's definitely still enjoyable.
The game is pretty much exactly how you'd remember it. I didn't get the items as soon as I felt was appropriate, but the pacing is very nice. The game also guarantees new shots each time you get an upgrade in every singe stage. There's also so much going on in each stage that you can't get everything in one single trip even if you had everything available to you. It doesn't milk any additional gameplay hours and has a very natural progression.
Most flaws in the game are either minor issues or nitpicks. Some pokemon are placed in ridiculous places where it's not likely you're going to get a good shot at all no matter how hard you try (Charizard and the poliwag come to mind). The camera is also a lot slower than I remembered and can cause you to lose precious time in getting that right shot. The graphics are dated but not distractingly so unless you see Todd Snap in a cutscene.
The most frustrating feature of all is whether or not a pokemon is in the middle of a frame. You have to make sure the dot you use to aim is right on the pokemon's body. If it's a narrow or fast pokemon, you're likely to get it in the middle of the frame without the dot being right on it, causing you to lose points despite it being a much better picture. It's incredibly picky and, paired with the slow camera, this easily causes some headaches.
Overall, this game could do well as a 3DS remake. With the 3D feature, updated graphics, and five new generations of pokemon to pick from, it could definitely become a good game to feature different play mechanics to new generations. It's worth playing if you want a different kind of Pokemon game.
If you can't get a hold of Pokemon Snap for the N64 but you have a Wii, I suggest buying the game off the Wii VC, which you can find in the Wii Shop Channel for 1000 Wii Points. No, I'm afraid I never used this feature of the Wii so I don't know how that translates out to someone who has used this. You can find ROMs for Pokemon Snap, but the only one that works is the one for PCs. Those who have Macs (like me) are totally out of luck. The Mac ROM doesn't work at all (trust me, I tried). Good luck getting a hold of it because it's more likely that Nintendo will remake the Hoenn games than they will for Pokemon Snap.