After using the Beta I think Win 7 looks promising for NEW PC's or custom built to spec.
It has a "My Documents" system that is more easily managed for households with multiple usernames and account levels and an easier network filesharing setup. Their current Windows Movie Maker is horrible though so I do NOT recommend downloading the beta of that.
I hope MSFT does two things: ditch 32 bit, all computers out there that will be able to run Win7 will be 64bit CPU's anyway so end the confusion and potential of people getting a version on training wheels with their new pc. And I hope they end the version confusion (basic, pro, ultimate etc... ad nauseum). A home user has just as much need for hard drive encryption as a business machine anyway and it costs them NOTHING more to add it so go back to 1 version with the option of turning features on or off and be done with it.
All this being said though I will not be buying Win7. There is nothing it can do that my Ubuntu 64bit Linux can't do better and MSFT has fleeced me one too many times in the past.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic