I’ve just reformatted my laptop, went to install CS4 and a prereq is Vista SP1. I couldn’t force Windows update to find it to download, according to Microsoft themselves this could take up to a month!
You can download standablone SP1 installs from Microsoft and just run that, I burnt a copy to disc for next time.