gorcorps
aka Brandon
No, a 2nd stick is for games where you move in 3D space so you can move the camera and your character at the same time. And it doesn't really matter if it's a 2nd stick or a 2nd D-pad. Look at SM64. Stick for movement, C buttons for camera.
I'm not sure why you'd site the 64 as an example of good controls. AFAIC it's one of the worst controllers in video game history.