LD: Soul Calibur for the Cube was pretty awesome.
Last night I got SM64 and played it with the Gamecube controller, it was alright, since you can use the L trigger in place of the Z button. However, I doubt any games that require a lot of use of the Z button will work, unless they substitute the Z button with the L trigger.