Some games that have effectively used the compute shader:
Dirt 2 (used it for about 2x the light sources of the console version. Relfections, shadows cast, from double the light sources was done mainly on the compute shader. DX9 version does not have this)
Lost Planet 2 (DX11 version has water simulation, walking through it the water in 3d reacts to walking or shooting it. Actual splashes not just a 2d flat shader.)
STALKER: COP (has AO in both DX10 and DX11. A higher quality version of AO is in the DX11 version and runs much faster than the DX10 versions due to being on compute shader)
So not only does it give us more quality. But some games like stalker actually run faster too. Its pretty easy to implement too. Both Dirt 2 and LP2 are on consoles as well as PC.