I never really found a problem with the camera, but that may have been because I was more focused on the controls really. And, I don't really play Mario games for the plot development, but I didn't think the plot was any worse than Mario 64. And I found the plot of Sunshine to be the best of 64, Sunshine and Galaxy.
I generally enjoyed all the levels, even if plenty were a bit too easy, the music was OK from what I can remember.
I give it 7/10. Sunshine got an 8/10 out of me, so did 64.