Is Microsoft Security Essentials any good?

According to the advertising, Microsoft Security essentials is free to Windows users (i.e. me), it's quick, and it's top-notch anti-virus, spyware, malware etc protection. It all sounds a bit too good to be true. Is it? Or should I go ahead and download it?
11 answers 11