To back that statement up, pretty much every "pro" app is multi core/processor aware. Programs that I have personally used and know are multi-core aware:
Vegas 6 (vid/aud editing)
Combustion
3d Studio Max
Mac programs: Final Cut Pro, DVD Studio Pro, Motion, Shake, etc
Obviously this is...