It generally works well for me. I am running an older version of frigate that uses the COCO model (I think you can have custom models now).
You can specify different object along with thresholds. My dog occasionally shows up as a false positive, and the only time it misses a person is when it is really dark and the person doesn't enter full frame long enough.