I used it for a brief stint. It looks pretty, but overall, the cons outweigh the benefits...
Unless you are interested in DX10 games and have a beast of a PC to handle the visual elements of Vista with ease, don't bother.
That said, SP1 is lurking around the corner, but I'd wait to see if it actually solves anything before upgrading.