It has two sides to it. It will ofcourse warn when downloading files with poor reputation but sometimes it will flag legitimate programs such as Windows Update so is disabled by default.

It just depends on the experience of the user.