The verdict

Local AI
Nvidia Tesla P4 has more VRAM (8GB vs 5GB) - up to ~8B (Q4).
Fit
Nvidia Tesla P4 is easier to add to a mini-PC (low-profile PCIe).

Which wins for each job

Job Nvidia Quadro P2000 Nvidia Tesla P4
Plex transcode ~18 streams ~18 streams
Frigate NVR ~25 cameras ~25 cameras
Local LLM 5GB VRAM 8GB VRAM win
Fits a mini-PC full-size PCIe, DIY build low-profile PCIe win

Approximate - capacity estimates from curated specs, the same logic as the recommender. Verify against your exact setup. Prices move; check the retailer.

Full specs

Spec Nvidia Quadro P2000 Nvidia Tesla P4
Price (list) $150 $130
Type gpu gpu
Interface pcie pcie
Transcode H.264/HEVC (NVENC Pascal) H.264/HEVC (NVENC Pascal)
Frigate detector TensorRT TensorRT
TOPS - -
VRAM (GB) 5 8
Low profile no yes
GPU sharing vgpu (unlock) vgpu (unlock)
Power (W) 75 75