SP2 was installed on both of my network machines with no problems once all except that, like you, I had to adjust my security settings and turn off the annoying "alerts".
The pop-up blocker added to Internet Explorer was a really nice feature.