Brad, SP2 makes my browser hang big time, even with the pop-up stuff turned off. As for audio, I have not installed it as my main audio computer does not entertain the thought of going "on line". Most Windows upgrades are for web purposes anyway, security. If you use the same system for audio as you do for the web, I would hold off on SP2 until Microshaft gets the kinks worked out of SP2. So far I say, I would not do it yet.
I do use my workstation that goes on line for editing and sample mastering. Even though it is very powerful, so far I have seen a speed reduction since SP2 was installed. I have had more crashes (files being diverted to temp files) since SP2. I would hold off.
These are simply my experiences.
Any others?