It depends on the app, like Pabster said. Windows will feel snappier, apps will load a bit quicker and heavy processing tasks (encoding, etc.) will also benefit greatly.
But games? Not nearly as much, as the bottleneck is in the GPU for the most part anyway in modern games like Oblivion and FEAR.