"...you rarely hear about the successful stories, only the ones with trouble. "
Much as I dislike M$ business practices and distrust them generally, gotta say that the 3 SP2 upgrades I did were hiccough free. No problems detected, and I run all sorts of esoteric software.
Your call