Nah all SP3 was a major Hotfix pack that covered everything from the last 7 years, and some network related items. Sadly no, XP wasn't going to get a visual upgrade either especially if you want the Vista look, and you want that your XP to look like vista, don't know why, you want to download the transformation pack which you the latest is right here. It is a service pack or rather the ultimate service pack just because it combines everything in a nice 342MB file.

It is funny though, that if you were to install SP3 it would remove all the old individual patches, and thanks for for letting me look into that if SP3 did or not.

Also if your having problems with the windows update or the Check build version of SP3 try this version out and see if you can get SP3 installed on your computer.