Apps have to be rewritten to use OpenCL anyway, so FCP's antiquated architecture isn't really relevant...
I've heard FCP is getting a rewrite, it's possible they'll use OpenCL. Adobe is certainly using a lot of CUDA in Premiere.
FCP certainly does use a lot of OpenGL though, so you can't go wrong with getting a good GPU. Motion is also heavily OpenGL dependent. I know a lot of people, however, who don't bother with OpenGL under After Effects.
Not sure why you say desktop graphic design doesn't require more than two cores. If anything, video and imagery makes the BEST use of multiple cores, more than any other sort of software. Photoshop, however, sucks at using multiple cores, but that has more to do with Adobe having their heads up their asses rather than a failure of multicore computing.