Nice! I think you'll enjoy playing SM64. Even if certain aspects of the game are a bit dated, it's still a very fun game.
For me, SM64 had a bit of a learning curve because it was my first 3-D Mario game, but I didn't find the game to be incredibly difficult. Some of the difficulty steps from camera issues - Super Mario Sunshine definitely benefited from the C-stick giving you better control of the camera.