The verdict

Plex
Nvidia RTX 4000 SFF Ada transcodes more streams (~45 vs ~12).
Local AI
Nvidia RTX 3090 has more VRAM (24GB vs 20GB) - up to ~33B (Q4).
Fit
Nvidia RTX 4000 SFF Ada is easier to add to a mini-PC (low-profile PCIe).

Which wins for each job

Job Nvidia RTX 3090 Nvidia RTX 4000 SFF Ada
Plex transcode ~12 streams ~45 streams win
Frigate NVR ~25 cameras ~25 cameras
Local LLM 24GB VRAM win 20GB VRAM
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 RTX 3090 Nvidia RTX 4000 SFF Ada
Price (list) $800 $1,250
Type gpu gpu
Interface pcie pcie
Transcode H.264/HEVC (NVENC Ampere) H.264/HEVC/AV1 encode (NVENC Ada)
Frigate detector TensorRT TensorRT
TOPS - -
VRAM (GB) 24 20
Low profile no yes
GPU sharing - vgpu
Power (W) 350 70