Q9550@3.5Ghz is more then enough for hd5870 unless its badly optimized game that can use only one CPU core. In all other cases its more then enough.
Application supporting run on GPU, just to name few:
ATI Avivo Video Converter
Adobe after effect
Adobe flash player 10
I am sure there is more, and will be in future, but those are all i remember.