I don't think it looks good. I like my Windows to be utilitarian systems, which is why XP under the Classic theme does it for me. For heavy work I like that layout. Which isn't to say I don't like OSX's eye candy, since I do more media organisation and day-to-day stuff in Snow Leopard the graphics never get in the way. I like and use Microsoft products every day but I still don't think they've got the design right yet. Win7 does some useful things but the actual visuals aren't my cup of tea.
Maybe I'm just odd like that.
My studio's musician just built a PC and is using Windows 7, he's not too keen on it either. Had to do a whole load of hacking and fiddling just to get a working midi input, it's still not right and has lag (compared to XP which had none).