In Feb 2007 I bought a mid range HP laptop (about $900) for my personal use and it came preloaded with Vista...I was looking for XP only and was going to buy one, but figured we all will have to go to it eventually when support for XP runs out.
I dont mind Vista, got used to it fairly quick and dont think its so hard to navigate once you get used to it....installed all my software was fine, I just had an issue with Dreamweaver but googled it and 5 minutes later had the patch installed no problems to report. Photoshop/Illy CS2 had no problems either, I think I heard Vista originally didnt run CS3 but think that is fixed now.
I bought the laptop with 1 gig of ram and well opening Photoshop was a dog....so I upgraded to 2 gigs now. It is pretty good and I can have photoshop and Illustrator open, but for some reason if I have MS Outlook and MS IE 7 open for awhile (with numerous tabs) - it locks up my IE sometimes for about 10 seconds. I dont know why, but I think Outlook is a memory hog and Vista doesnt just sip away at the memory, it takes huge chunks and hordes it (or leaks it). Photoshop sometimes hangs for 5 seconds when first opening it too, but after that its not a problem.
I havent upgraded to Vista SP1 that just came out a few weeks ago, but hoping when I do that my memory issue(s) goes away. The memory issues arent a deal breaker, just an annoyance since they dont happen all the time (and could be related to Virus scan or other software).
Overall Im liking Vista and give it a B- and think XP is less of a memory hog, but Vista has some cool built in features as you mentioned. Oh Im using Home premium btw.
-Hoppers
PS - I also made the explorer look more like XP pretty easily...and turned off the UAC (user account control) since that was fairly annoying.