Not always - it depends on the app you're trying to run.
Throwing 2 vCPUs at the VM will potentially cause unnecessary load on your host.
If you have an app that will utilize two CPUs in the VM and you need the performance, then by all means, sure - use it.
But don't just enable it because it's there -- if you have a dual-core host, leaving one CPU in the VM always leaves one core available for the host, which is best for both. If you enable 2 vCPUs in the VM, there will be times when Fusion has both cores of your host processing VM ticks (when they're not needed) and your host may have to wait.
EDIT: Oh, and don't forget to install the VMW Tools in the guest. That gives you an optimized graphics driver, mouse driver, balloon memory driver, and other goodies which are really required to get decent performance.
Mike