This might not answer all of your questions and I only have very small number of cameras, but I would recommend to buy any IP Camera that supports RTSP and then create a seperate VLAN or LAN for the cameras to not be able to phone home or anywhere else. I actually have a complete isolated smarthome network using a opnsense Router and it works Quite well and at least feels safe.

Another way could be to invest in unifi / ubiquiti cameras, they have a good Reputation. Integration in frigate or homeassistant I dont know.

The shelly Sensors are really nice.

Finamp, very polished, actively developed and cross Platform. Requires a jellyfin instance. But thats a nice diy project in it self, can only recommend