When would upgrading the processor of the top of the line Macbook Pro make sense?
Turbo Boost is good for anything that uses a lot of CPU. It basically over clocks the CPU while it's needed and when it's not needed it doesn't run. 

It would help with anything that runs weighs down the CPU. I don't believe that it does anything with the graphics card (but I could be wrong).