If you're looking for an N64 RPG, there is only one choice: Ogre Battle 64. Best Ogre Battle game, best N64 game.
Lost Odyssey and Fallout 3 are my picks for the 360. If you're looking for something Dark Cloud-ish, try ActRaiser? It came out on the Virtual Console.