Who wants a fixed cursor when pointing at your enemy is much more intuitive?
The only problem I see with it is that you have to point and turn past your enemy in order for the camera to center on it. Still a minor problem since you can immediately shoot your enemy once he's on the screen. This is superb for instances where you face multiple enemies.
I think once we get use to the fact that the enemy doesn't have to be directly in front of you to shoot him, we'll see greater mastery of gameplay.
If you haven't checked it out already, I'd suggest going to IGN and watching the video that showcases the entire MP3 demo. It shows you the hightened sense of accuracy that is only possible with the Wii.
Also, what if the nunchuck could be used to sort of "nudge" the camera along when you need it most. For instance, let's say your shooting an enemy and then he quickly jumps sideways out of view. Well, kinda thrusting the nunchuck in the direction needed will move the camera half a screen. I think something like that could become very useful and put aside many of the so called "complaints".