I am happy with it. The non-power user should be much more protected now which should in turn protect us. I think anyway that sp2 was built and designed out of the ashes of stupidity from all the people who do not know how to even click a hyperlink properly.
I mean it would take one of us coomputer geeks 5.245 seconds to realize something is up with our pc (Trojan, worm, virus, spyware...) but the average mom and pop user would never have a clue cause they do not even know what to look for.
SP2 should considerably cut down by preventing the "bad stuff" from getting in.