This is Canon HF10 PAL test. 1/50 shutter speed and auto exposure (hand shot). The distance of subject (fruit) is approximately 40cm. I also, used 37mm adapter telephoto lens (2x) and edit in Vegas, applying sharpness and studio_to_computer_rgb filters. Off course, the original rendered file (1920x960) is much better quality.
I have no idea other camcorders also have fireworks mode but I guess Canon Hf 10's fireworks mode is really appropriate for taking firewokrs shot.
I compared TV mode (chaged shutter speed as well as exposure ) and AV mode. Both are not better than firewoks mode.
Moreover, I feel "noise" were much decreased ; thus, if you need less noise shot when you have not enough light, you may use fireworks mode.
I didn't try it, so not sure
anyway, Canon HF10 is great