I actually have the original cartridge of Pokémon Snap for the N64 (then again, I don't have a Wii, so it wouldn't make much sense for me to have it on the Virtual Console). I'd have to echo the sentiment that it was entirely too short – though, I don't think having more Pokémon in it would help that. It just needs more substance, is all. The on-rails photography is what made it difficult at some times too, since you'd only have a small window of time to get what you needed. I remember when I was younger that it'd take me forever to figure out how to go on from the Cave area (into the Volcano area).
I was actually debating playing it over the break this weekend, though I'd have to get through schoolwork, then the temptation to play other things, like Devil May Cry, Killer7, or Rogue Galaxy. Oh, and of course, XD and/or Colosseum.