I'm running on SP2 (Final / RTM became available earlier today)
General use is noticebly more responsive, although I haven't ruled out the placebo effect yet. - Windows do seem to open quicker though.
Nothing so far fucked, everything I have runs as it should.
Not benchmarked or tried UT2004 yet though.