Reolink cameras, cloud not required. Poe is perfect, but wifi works too if you don’t have a central NVR (since it won’t be constantly streaming). Right now, i have them set up to record on motion to their internal sd card and upload to my own ftp server. I dont require 24/7 recording so this works well for me. If you do need it, have an nvr and poe connected cameras and thats pretty much it. My setup allows me to access the video files however i want, the stream however i want and have no third party cloud provider.

Raspberry pi is power limited. HDD creates a power spike on boot as well so you may have power issues. When i used a rpi for a media server, i had to use a 25W supply. Even 20W wasnt enough and i had voltage throttling issues. 1TB HDD probably wont draw that much power but SSD is never an issue. If you dont need space and are on a budget SSD is the way to go. This is all assuming USB is used for power.

If you need large amounts of space and have a budget, use an HDD but it needs to be self powered or used with a larger device like a mini pc which has adequate internal power.