Does anybody know what developer made Conquer's Bad Fur Day? That game has one of the best multiplayers ever, not to mention it is hillarious. And for you Banjo Kazooie fans, its essentially the same exact style of play (also somewhat similar to mario 64, but somewhat different)
And while 007 is a great game, i do not know that it will be so great the second time around. It was unique at one point but now it seems that everyone has copied/improved on it. I would only get it for nostalgic purposes only, but if I want those I could always just hook up the 64 and play there, so this one is a no.
I would get Ocarina, but I dont have time to get into that game - and again, i have it on 64.
Starfox is good because you can beat it in under an hour - always a classic to compete for high scores.
Essentially, I think any game that had an aspect that was fun and could be done in under an hour is great. So short games and multiplayer games are on my list for potential downloads. If I want a month long RPG then I will just go get my 64 and hook it up. You could also probably buy some of these games (64 cartridges) at a store for less than the cost of a download plus memory.
I dont think I will use virtual console too much for 64, other than conquer and starfox if it is made available. I wish the wiimote was backwards compatible. I would love to play RBI baseball from NES with the wiimote.. . . oh well