I use an Xbox controller for N64, it works quite well. I tried using a gamecube controller (since the button layout is closer) and couldn't get it to work right! The analog stick didn't have enough range towards the front (very odd).
For the xbox controller, I suggest A for A, X for B, Y for Z and the right analog stick for the C-buttons (as mentioned).