I know several people who loaded SP1 onto machines that where working fine - now they have all sorts of problems (seems SP1 doesn't like some 3rd party software)
I would suggest if your machine is running OK leave it alone and only load SP1 if you are having problems.
If you are concerned about a particular security issue then you can upgrade just that fix through the MS website. Remember BACK-UP before you do anything.