my most successful project was an inverse problem for mining - taking a bunch of seismic traces and, from that, calculating a 3d map of the source structure (microseismicity - this technique is called SET (seismic emission tomography)). there's an abstract here - http://adsabs.harvard.edu/abs/2010AGUFMIN41A1352D (if anyone wants i can send them the poster, if i can find it!).
incidentally, the AMD OpenCL implementation worked fine on Intel processors already (and has done for a year or so now). i made some notes at http://www.acooke.org/cute/Developing0.html
it's very similar to cuda, but has a couple of advantages. first, it's really well supported on macs. second you aren't stuck with nvidia's hardware (their support is terrible - had a client stuck waiting on results for weeks because they wouldn't respond to issues that eventually turned out to be a failed board). the main disadvantage is that the associated tools/libs aren't as mature.
and a final piece of advice - if you have a finite budget, and don't need 64bit support, you get way better performance per $ using average gaming cards rather than their top-end GPU hardware (although i suspect we'll try out amazon's gpu cloud stuff soon and avoid our own hardware for projects that don't have huge data sets).
Don't for get that GPGPU is becoming hotter and hotter now that the computing devices blend and become heterogeneous (i.e. CPUs come with embedded GPUs, GPUs doing general-purpose computations, special acceleration hardware, etc). OpenCL is supposed to help with programming these devices.
One of the things they are trying to GPU accelerate is improved MRI scannings - imagine taking images for every 1mm and then stitch it together so that you get a 3d model of the area which the doctors can look at from every angle.
Unfortunately that takes way, way too much computer power to be feasible today.
I'm guessing OpenCL is being used to accelerate Marching cubes or some other similar algorithm
http://en.wikipedia.org/wiki/Marching_cubes
This post by Smash of Fairlight http://directtovideo.wordpress.com/2011/05/03/numb-res/ talks about some of the reason why you want to do this but in a very different context
But this is far from the only thing people use it for. Basically it is used, or might be used, anywhere else you would use a cluster.
Here [http://www.youtube.com/watch?v=14ZSXCqOML0] is a real-time rendering of the Julia set (in 4D, so you are really watching the projection).
See poclbm.py[1] and others.
And, if you can use CUDA to accelerate stuff like that, you can use OpenCL.