I have seen a few times people suggest used SFF pcs like a dell optiflex as a replacement for a raspberry pi. Is there anything to look for specifically or ones to get/avoid? I have searched this sub and have not found anything that was recently suggested. Right now just looking for something to run home assistant and frigate. Down the road may add more.
For HP, you'll see a model like an HP Elitedesk mini 800 G4, for instance. Elitedesk will either come in a 705 or 800 - this is just AMD or Intel. Prodesk will come in 400s or 600s - this is mostly chassis and cooling for differences, with anything ending in a 5 being an AMD model. The "G4" part is the HP generation number. A G4 corresponds to a 7th or 8th gen Intel or a Zen1 CPU (or Celeron/Athlon equivalents on the low end). These numbers line up with their SFF and full fat desktop brethren, for reference.
All of these machines can come with 35W, 65W, and 95W TDP CPUs (or closest to those numbers in the case of the AMD CPUs). If you are looking at the minis, you'll want to avoid the upper end (which are all K-series CPUs) on account of the fan needing to constantly run to cool them. Usually a T-series (or E-series for AMD) CPU will have the same power draw as a non-T CPU, but lower performance and lower peak heat production, which is actually important here because of how small these boxes are.
Depending on how old you go, the minis mostly have either an M.2 slot plus a proprietary port for SATA (2.5 inch drives only) or two M.2 slots. There is a configurable portion the back that can be anything from a VGA/D-SUB out to a Thunderbolt port or even a full dGPU (which would also use up the space for your SATA drive). If you buy off-lease hardware, it is almost always the former, but swapping these out are super simple. Just make sure the part exists for the exact model of miniPC you want - they get stupid specific on what is and isn't compatible.