Visual Studio Team System Testing

We are currently evaluating tools to aid us in creating, administrating and executing tests. Development is done in Visual Studio 2008. I would really like to get some input from any testers and developers using this part. Is it good, great or do you hate it and why?

We most likely will evaluate the product this spring but it would be nice to get a head start by reading other peoples reflections beforehand.