I've had XP-SP2 since it was released, on both work and home machines, and have encountered minor problems at worst.
A lot of people are screaming about SP2 being bad because they're just MS bashers and hate everything that MS puts out, good or bad.
So far I've half fallen in love with SP2's new security and blocking features for IE, and there have been some subtle file navigation issues that I've discovered and liked. The active desktop has become a little sluggish on my home machine, but that is because my home machine is OLD. Also, there's these new processes (inet*) that are okay...but one of them sucks up nearly 8 megs of RAM just to run, which blows. Soon as I find out what it's really doing and how much it'll effect the new features to have it "removed" I'll do so.
Other than that, SP2 has been pretty seamless.