Wastewater-based epidemiology (WBE) has historically proven to be a powerful surveillance tool, particularly during the SARS-CoV-2 pandemic. Effective WBE depends on the sensitive detection of pathogens in wastewater. However, determining the process limit of detection (PLOD) of WBE through a comprehensive evaluation that accounts for pathogen concentration, nucleic acid extraction, and molecular analysis has rarely been documented. We prepared dilution series with known concentrations of S. Typhi, V. cholerae, rotavirus, and SARS-CoV-2 in surface water and wastewater. Pathogen concentration was performed using Nanotrap particles with the KingFisher™ Apex robotic platform, followed by nucleic acid extraction. Quantitative real-time PCR (qPCR) and digital PCR (dPCR) were used to detect the extracted nucleic acids of the pathogens. The PLODs and recovery efficiencies for each of the four pathogens in surface water and wastewater were determined. Overall, the observed PLODs for S. Typhi, V. cholerae, and rotavirus in surface water and wastewater were approximately 3 log10 loads (2.1–2.8 × 103/10 mL) using either qPCR or dPCR as the detection method. For SARS-CoV-2, the PLOD in surface water was 2.9 × 104/10 mL with both RT-qPCR and dPCR, one log10 higher than the PLODs of the other three pathogens. In wastewater, the PLOD for SARS-CoV-2 was 2.9 × 104/10 mL using RT-qPCR and 2.9 × 103/10 mL using dPCR. The mean recovery rates of S. Typhi, V. cholerae, rotavirus, and SARS-CoV-2 for dPCR in both surface water and wastewater were below 10.4%, except for S. Typhi and V. cholerae in wastewater, which showed significantly higher recoveries, from 26.5% at 4.6 × 105/10 mL for S. Typhi to 58.8% at 4.8 × 105/10 mL for V. cholerae. Our study demonstrated that combining qPCR or dPCR analysis with automated Nanotrap particle concentration and nucleic acid extraction using the KingFisher™ platform enables the sensitive detection of S. Typhi, V. cholerae, rotavirus, and SARS-CoV-2 in surface water and wastewater.