I use a old phone with IP cam on it, and only allowed local network access connected to my home assistant.

I can view it remotely via home assistant cloud, which is E2EE from instance to phone.

I presume Raspberry Pi Camera is also a great solution. And also I dont put any camera in bedroom or bathroom, because there is no reasonably accessible entrance there.