Little Snitch & co are part of a defense in depth strategy against malware and other threats.

Will it catch everything? No, obviously. Will it catch enough things to make it worth running? I guess that depends on your threat model, but many think it's worth it.