The beta was awful, and MS even admitted that it had huge compatibility issues with many popular software titles.
Unfortunately, I think it will be up to the individual developer to make their software compatible with Microsoft's. Personally, I'm all for added security but at what cost?
When the SP2 Beta was fresh, MS had said they knew about compatibility issues, and basically it was too bad. I think I'm going to hold off on the SP2 download for a month or so, and let everyone else work out the bugs for me.