Fighting games -- if you like traditional 2d fighters, the N64 doesn't have much. It does have some okay to good 3d fighters, though, including the Fighter's Destiny games, Dual Heroes, and Mace: The Dark Age, and of course SSB, which is fantastic. And as for RPGs... if you mean traditional JRPGs, sure, all it's got is Paper Mario. Paper Mario is a fantastic game, but it is only one ~30 hour title. Apart from that, many JRPG fans will like the Japanese strategy game Ogre Battle 64; it's an exceptional game for sure. There's also Quest 64, which almost everyone hates but I've never played. For Western RPGs, Aidyn Chronicles is about it; see my review in the OP to see my thoughts on that good, but seriously flawed, game.
The N64's library is strongest in racing games, 3d platformers, FPSes, and other 3d action-adventure games.
For Duck Dodgers, no, I don't own everything for the system yet... I have a lot of games, but not everything. That is certainly a game I want to play.Also, no Duck Dodgers, Densha de Go, or Derby Stallion 64? Fushigi no Dungeon is decent too. Mario Golf is quite a good light game; you can also annoy your competitor during his swing with obnoxious noises; the courses have music too, not a common feature in golf games and always much needed.
Aha, and you like Indiana Jones, a good sign.
For those other two, I don't own any import titles, US releases only. And a horse racing game and train sim would be VERY low on my list I think, based on their genres at least... I don't know much about the games in specific. There are some import games I'd like to have, and Shiren 2 might be on that list, yeah (I'm sure I'd find it really hard and frustrating, but it clearly is good for its genre), but I don't know about those two...
As for Mario Golf, I don't like golf, and can't think of any golf game I've ever really enjoyed. I like some minigolf games, but golf? I find them boring at best, and almost always dislike them. I have very little interest in Mario Golf...
On the note of missing games though, no one's commented that I don't own Goldeneye yet? It is true. I did borrow the game from a friend back in 2000 and finish the game on the normal setting, so I have beaten it, but I never bought it after that; the game's nowhere near as good as Perfect Dark, so I've never thought it'd actually be worth the money. I mean, it's good for 1997, but honestly, today, I'd rather play any of the other three 1997 N64 FPSes over Goldeneye, probably... not saying they're better overall, but I'd rather play them today (that is, Hexen 64, Doom 64, and Turok 1).
Oh, The World Is Not Enough is as good as or better than Goldeneye too. It's a clone of course, but it's a good one. Goldeneye was somewhat revolutionary in 1997, but later titles exceeded it. OH, and Goldeneye's story is awful, too, and makes next to no sense unless you already know about the franchise and movie. When I first played the game I'd never seen a Bond movie before, so I had no clue who any of the characters were or what was going on, but very little was explained. The story only made any sense at all after I watched the film later on. Perfect Dark, in contrast, actually does a fine job with its storytelling.
... You actually liked Quest 64, or are you not being serious? Because SSB is a great game.@ cowboyscowboys = Super Smash Brothers, Dual Heroes, and Quest 64.