Windows defender is purely anti-spyware. Some AVs do not also protect against spyware, so in that sense it can be useful. If you have MSE, AVG, Norton, or a plain anti-spyware program, you can feel free to turn it off if you want to.
Also, I got some weird spyware on XP once that was removed with Windows Defender. Never heard of it really helping any one since.