If one clicks the targetting trigger all the time, then no wonder why the camera would be behind Link so much, whether's it's WW, MM, or Chocorina (I miss Choco Island). The auto-cam was too close for my tastes in each of those Zeruda, so giving myself some extra room was appreciated. Also, as soon as one adjusts the C-stick in WW, the camera stays in Manual Mode and acts "dead" as it maintains the same angle since it's just waiting for more user-input. To get it back to auto-cam you'd have to give the L-trigger a tap. I don't see this as a flaw, though, since it's largely up to the player to be aware and chose the right orientation (like, not touch the c-stick AT ALL if wished)
Me, I love WW's manual camera. Like in Mario Sunshine, I'm ALWAYS using it. Running, jumping, sailing, flying, whatever. I use it to maximize presentation-badassness-factor.