Yup. I played it through back-to-back on the GameCube, then once again on the Wii. I completely agree that the motion controls improved the aiming and shooting, made them more fun and made the knife far more useful than it was when it was paired to a button press. I never used the knife on the GC version, but I used it frequently on the Wii.
Its been ported to nearly everything at this point, but the Wii port is still my favorite version.