In late Sept / Oct you should not have any problems driving SFO-SEA. Maybe a bit of rain as you head up the coast but it is not like you will see snow or anything. Typically it should still be in the 20's (low 70's for the F folks), during the day.
Do the drive, it is amazing.