I wouldn't say worthless, especially in a corporate environment for preventing bittorrent shit, etc. I also still see a number of DDos attacks out in the wild, we had a recent one where a girl on xbox was getting ddos'd because she was a girl I think and it wasn't masking her IP. And they are one of the reasons why worms really aren't a thing anymore. You kinda need your security to be comprehensive and end to end, people hiding things in usb firmware, etc. I do agree a pihole is probably 100x more beneficial currently for any home user.
I'm really liking the nextgen antivirus stuff, behavior based, not signature. Can tie it to your firewall, a cloud sandbox, etc. and it makes the decision and tells all the devices. It sees something trying to open powershell? nope. Doesn't matter what it is, outlook item, zip, macro.. just says no, and tells the firewall to block it.