I find it really useful. Sometimes I search for something obscure, and when it gets past the safe sites, you start to get red warnings instead of the green safe status.
I never click on a red warning site. I wouldn't. Looks to me like they could contain viruses or malware.
Sorry, no idea how to switch it off. Hopefully someone else wil know.