All my software is back on now, and things are pretty much humming along nicely. A lot of what SP3 has done is consolidate all the security updates since SP2.
There are a few under the hood changes, but nothing revolutionary in my opinion. Still, it does breathe new life into XP and that's a good things since it's my OS of choice.
Now my next step is installing Vista on my fiancee’s laptop. That may get a little tricky but I need to do it in order to learn to support Vista.