Pihole just gives tells you what computer made DNS queries and to where. Littlesnitch/tcpdump/wireshark/glasswire(I think?)/opensnitch are system level tools t

Pihole just gives tells you what computer made DNS queries and to where. Littlesnitch/tcpdump/wireshark/glasswire(I think?)/opensnitch are system level tools that attempt to monitor the individual connections - which processes made them, where they were too, and tcpdump/wireshark will also show you the content of the connection. If malware uses ip addresses or it's own dns server then Pihole will never see it. Snort and Suricata are more likely what you're looking for as an IDS for something network wide, they analyze network wide the individual connections and can do pattern matching with known malware lists. They can't tell you what process made the request. A pihole certainly wouldn't hurt and is very easy to use, it's not really made to be an IDS AFAIK.