I've been running Vista Home Premium on one computer since January and Vista Ultimate on another since November. I rather like it. It's more secure and a lot of the administrative tasks are easier to perform, though I dislike the new way the "All Programs" menu works.
I don't really know what to say. For pretty much everything my wife or daughters do, there is no real difference between XP and Vista, other than Vista looks better. For myself, I occasionally run into an issue where I need to run something as an admin, but that doesn't really bother me and Vista handles that very, very well, IMO.
If you're getting a new machine that comes standard with Vista, you shouldn't have to worry about driver issues, which is the main reason I advise people not to upgrade their existing machines (and, even that falls into, "You may be spending money for a wash.").
For new machines, I tend to advise: Don't fear Vista.
I probably wouldn't go too far out of my way either way. Actually, I would, but that's because I like new toys. For the average user, Vista is just fine -- at least as good as XP on a new machine.