Digidesign ProTools8 needs and uses all the cores it can get.
I would guess all video/photo/audio recording/editing software take full advantage of all the cores.
There are actually people that use their pc's for other things than surfing or word/excel.