The verdict

Plex
Nvidia Tesla P40 transcodes more streams (~18 vs ~12).
Fit
Nvidia RTX PRO 4000 Blackwell SFF is easier to add to a mini-PC (low-profile PCIe).

Which wins for each job

Job Nvidia RTX PRO 4000 Blackwell SFF Nvidia Tesla P40
Plex transcode ~12 streams ~18 streams win
Frigate NVR ~25 cameras ~25 cameras
Local LLM 24GB VRAM 24GB VRAM
Fits a mini-PC low-profile PCIe win full-size PCIe, DIY build

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 RTX PRO 4000 Blackwell SFF Nvidia Tesla P40
Price (list) $1,500 $300
Type gpu gpu
Interface pcie pcie
Transcode H.264/HEVC/AV1 (NVENC Blackwell 4:2:2) H.264/HEVC (NVENC Pascal)
Frigate detector TensorRT TensorRT
TOPS - -
VRAM (GB) 24 24
Low profile yes no
GPU sharing vgpu vgpu (unlock)
Power (W) 70 250